How much are optical drives being used for general, non-archival storage though? It would be inconvenient to store data on a disc that you intend to access on a regular basis, so that's not likely a common usage scenario for them. And an SSD isn't going to help for something like storing video on a disc for playback in DVD or Blu-Ray players, nor are SSDs well suited for distributing data to others relatively inexpensively. Each has different use-cases.
I was thinking of that, although technically one could burn malware to a disc and add it to a stack of blank media before it makes its way into the sensitive environment. Though really, you probably shouldn't have autoplay enabled for any types of external drives in that case.
Of course, if you have something like a bootable OS or other utilities burned to a write-once disc, you shouldn't need to worry about an infected system corrupting them. Or modifying any data files, for that matter. Data stored on an external, user-writable drive could potentially be encrypted by ransomware when connected to a system, for example, but write-once media will generally be safe from tampering.
I do have to agree with the notion that optical drives in general have become much more of a hard sell over the last decade or so. Even a decade ago, most PC users were making relatively little use of them, and that's only gotten worse as internet speeds have continued to improve and the price of other storage options has come down. Back in the mid-90s when read-only CD-ROM drives were becoming common, they were incredibly useful, as the amount of data a single disc could hold was on a similar level as the capacity of an entire hard drive, while internet speeds were incredibly slow, if available at all. So they became the primary means of software distribution. Then writable drives made it possible to store large amounts of data for far less than any other option, and DVD drives helped keep up with the increase in hard drive and file sizes.
But by the time Blu-Ray drives came out, they were well behind the curve of hard drive storage capacities, and PC software was already moving to online distribution, and could typically fit on a DVD if physical distribution was required. And the only real mainstream use-case, playing store-bought films, was hampered by excessive DRM. So, Blu-Ray drives never became more than a rarity in PCs.