LTO drives are expensive but well within the means of the average programmer or sysadmin. https://www.ebay.com/itm/198052084090
Optical media is an absolutely terrible format for long term archiving.
mDisc is an optical format designed, and tested for 100+ years of storage, can be read from a consumer dvd player and cost <$10 a disc.
No, that’s insanity.
TBH, pursuing this type of nerdery is just wasting time to excuse not curating stuff.
All electronic media is bad for long term archiving. People who restore things for a living over a period of many years transition media regularly.