I’ve always wondered what people are doing to them? Maybe I just got lucky. Maybe I was just careful with them. Maybe I don’t remember the ones that failed.
I don’t think kids are less careful now, although being screamed at for making the CD or record skip was probably a deterrent.
Lots of kids will handle them however they want. They'll pick them up with greasy, sticky hands right on the media section. They won't necessarily care about ensuring they're properly in the drive tray. They'll jam all kinds of things into the drive slots. They'll drop them on the floor and step on them, toss them in a toy box when told to clean their room, etc.
Obviously not all kids will be this way, but many will.
Like you, it never occurred to me that I can also just use specific DVDs or CDs as hooks for videos to be streamed, or media downloaded on a hard drive. So that suddenly makes the whole project a lot more interesting, and possibly easier too.
Buying a large pack of burnable DVDs is a lot cheaper and sustainable than using SD-cards like other commenters suggested.