I’m sorry to say that this is a rather naïve approach to long term preservation of data. There are surprisingly few solutions to preserve consumer data for more than a decade or so. If you really want to preserve your data for, say, decades, much less hundreds of years, then you need to think beyond the storage media you’re currently using. Even CDs fade after merely a few years of safe storage, leading to errors and data loss in the long run. Thus there are a multitude of factors you need to take into account before storing data for longer than a decade or so.
Well, over last two decades my mp3s, flacs, avis, mkvs, pdfs, epubs and others moved between CDs, DVDs, HDDs to land at a ZFS array replicated to another ZFS array at the moment. The way I use them has changed over the years (cloud streaming from navidrome, kodi for local playing, azuracast for radio broadcast etc.), but the media files themselves are the same.
As long as you don’t have real media files or other codecs that have disappeared (or will disappear - imagine if we move to a new cpu instruction set, I assume not every codec library will be recompiled).
If you maintain lossless storage you can switch formats as necessary; the problem really becomes a major issue when you have various formats you don't use very often and you don't notice that something became unplayable.
Luckily the number of people obsessed with emulating old systems saves the day for now. But at some point things like Video CDs and the Compact Disc-Interactive systems may fully fade into history.
This isn't really happening much any more. Spinning-platter HDs are barely increasing in size any more (I got a 4TB portable drive 5 years ago that I still use; now, looking at what's available, 5TB is the max and 4TB is still at the high end). SSDs are growing, but still not cost-competitive with spinning platters, and not really reliable for long-term offline storage anyway like spinning platters.
There just isn't that much demand for large-scale storage, since everyone just keeps their data "in the cloud" or has subscriptions to online services now. 20 years ago, HD sizes were doubling every year.