As for CDs, they are virtually worthless because streaming is such a superior delivery method for digital music.
Years ago I ripped my CD collection to MP3s and was done with them (CDs) forever.
Actually it’s the kitch factor.
Younger folks just stream music...
If they are going to buy something physical they tend toward vinyl due to it being something physical and differnt.
Lets face it, watching a record spin and dropping the needle etc, are far more a tactile experience than plopping a CD into a player and closing the lid.
They already have all their music on Spotify or Apple Music.. they are buying Vinyl because its kitchy, not because they are preferring the sound etc.
Records can and often do sound great but overall, I think CDs sound much better because they have none of those problems and they huge dynamic range.
How an album is mastered has a lot to do as far as how good, or bad, the final print is and that's regardless of the medium.
As far as streaming formats go 44.1khz 16 bit files (CD quality) ones sound great as do other "lossless" formats. But man, when you get to mp3 files, especially low res common types like 128kps, they sound ratty - I cringe when listening to them. Even high res mp3 files like those mastered to 320kbps have a "rattiness" to them compared to lossless formats.
I miss those “pops” Skips and scratches on CD! I am VERY careful with my vinyl. Some I bought fifty five years ago are still in great shape!
Now lets have some stackable record players so we don’t have to stop every 15-20 minutes to change or flip records!