Pressed CDs should last much longer than CD-R.
Floppies are really just tape in a disc format, and use heads to read high and low signals and deduce the 1s and 0s.
It stands to reason they should last quite a long time considering audio/video/data tapes can last over 50 years.
I wonder what the capacity of VHS tape is, given the restrictions of the NTSC modulation? I believe, back in the 80’s, someone made a ISA card for PC backup to VHS.
NTSC video signals offer a lot of bandwidth but very very few promises about the quality of the reproduction of the stored waveform