I've got hundreds of games on floppy disks from the early 80's, and the only ones that have died had mold on them from being kept in poor conditions. Treat your games right and they should last a long time. Most cartridge games should outlive you.
As for pat, if it's not Nintendo USA related, I'd take what he says with a grain of salt or two.
As for CD life in general though, I'd say PCE games should last longer then any modern disc based game. These days optical media is produced as cheap as possible, and with modern formats of cramming as much on there as you can, quality drops fast. DC GD-Roms are basically insanely over-burned CDs, ignoring every "safety precaution", so those dieing is really not surprising.