If you care about your data, you need to have a regular process where you check the copies and remake them from time to time.

Hopefully some of the copies live on after your death. Optical does well, but I've seen reasonably treated cd-rs degrade, and well treated pressed cds decay. Sometimes some mistake in production takes years to become apparent, but results in a fixed lifetime below the estimates.

I have so many CDs/DVDs that cannot be read anymore that I stopped using them for backups.

Regular optical media can suffer corrosion of the aluminium reflector layer, and breakdown of the dye. Sure, they do make archival grade discs (e.g. with a gold layer) but they're expensive.