Did you have cd boom box player in the 90s? Like this... Those chewed up and ate cds in short time. Maybe I just had a shit brand one back in day. Once I got a Sony good one in late 90s it didn't scratch disc but the early cheap ones sucked. Don't get me started on not treating disc right. Hell even my GameCube games that I'd keep in case but play constantly like Mario kart double dash are scratched to shit but still play. Disc suck. USB or cartridges are far superior.
I never used CDs in those, they already chewed up cassette tapes on a regular bases. Those things are only good for radio.
Anyway I've lost far more from faulty memory cards, USB sticks, HDDs etc than from CDs. Floppy discs though, ouch. I've had plenty disc read errors on consoles, but it was always the disc drive, not the disc. From all the discs I've bought over the decades I have one blu-ray with a repeatable scratch, one music CD and one PS2 game. HDD failures at least 10, memory card failures and USB stick failures far outweigh any disc failures. However cartridges have held out well. My GBA game cartridges all still work and even the box of Intellivision cartridges my wife bought at a garage sale all still work.
I've had more CDs and DVDs scratched or stolen then lost USB drives. I keep everything on my main computer and transfer them to USB drives. Unless someone walks out of my house with my main computer or extra laying around USB drives with my collection on it then I still have my music library. I understand it though when comes to video games I prefer physical. I have a few games worth 100+ each now which ate usually rare gems that have cult following like fire emblem early games and rare N64 games. Some people love vinyl because apparently sound is better. Early disc just were eventually a negative thing for me even though bought CDs up until 2000s or so. To each their own.