I’m in a similar boat. The USB to SATA adapter has kept my 5.25” drive going for quite a few years.

Some of my discs are hitting a decade and I am about to create a new set of backups. The market is smaller but the portable blu ray drives are becoming the default now.

So far I’ve just kept extra discs on hand plus a backup portable drive. Hopefully blu ray discs will manage to stick around as long as writable dvds.