"Eventually the CD might not be supported,"
welcome to the 21st century where music is listened to on phones. devices that are obsolete in 2 years but can store all your music on a tiny bitty chip unless you've been torrenting the best music of the past 100,000 years.
as to 'not supported' there are chinese firms still selling 8 track tape playing devices, despite the fact that all of the remaining tapes should have deteriorated now. they also sell vhs decks which the local wal-mart actually has a model on the shelf. blu-ray playback is not going away anytime soon. i have 2 bluray writers, one for the desktop and one usb powered one for the laptop(s). reel to reel tape decks may now be considered obsolete but there are people who still use them in the industry.
there will be pushes to make new fancier stuff, yes. it is called marketing. the vast majority of my cd-rs are still readable and only some of them have bitrot. but i wasn't organized with my cd-rs so i have a considerable number of discs i don't really know if i still have the data or not. most of the data isn't really mission critical and despite losing my music collection about 4 times now (from windows formatted hard drives) the back ups cd-rs and dvds and now 1 bluray, i have only lost 1 song to bitrot 1 song and it was all because i had backups that survived longer than hard drives.
i recommend HDDs and BD-R discs for backup. BD-R while subject to bitrot are still the lowest energy overhead per GB in the consumer space. HDDs are the cheapest per GB but if left running so as to automate backups draws more power and powering off a HDD in the consumer space means you have to be there to power it on for archival use. though there will at some point be a 'smartphone' app to remotely put them to standby via software. this can already be done with a NAS and Wake-on-LAN and a little scripting. but then the energy requirements are significantly higher on a NAS than on a usb hdd. anyways using both media HDD and Blu-ray offers a better chance of not losing everything. flash memory is nice but i wouldn't expect it to last forever, my compact flash devices suffered from an issue where the memory would take more and more power from devices until the cameras running them couldn't power them from fresh batteries, could have been the camera but it is hard to say but i wouldn't consider any flash memory as reliable when compared to hdds and bluray devices.