Flash and streaming.

Flash because it's cheap enough, high density, arbritarily scalable for whatever storage is needed.

Streaming because the difficulty making any optical rewritable (especially with respect to write speed) meant the niche overlapped with bluray and DVD, but why bother with yet another optical disk for films and games when bandwidth becomes more important than single-disk capacity.

There's also a bunch of technical difficulties, but when there's no market for the result, R&D efforts are often less well funded: https://en.wikipedia.org/wiki/3D_optical_data_storage

Some combo of flash and spinning rust storage really makes the market for very high capacity optical storage a bit niche. It might still have a place as archival media (and multi-layer optical disks, which are 3d optical storage of a sort, though not to the level of sophistication imagined in the 90s, are used in that role to some extent), but it's just really hard to see it rivalling flash for mainstream applications at this point. In particular, flash is really, really, _really_ fast.