Floppy's definatly do deteriorate.
Hard disks are sealed, and should be good as long as the electronics and mechanical parts hold out, and we have hardware that talks to that interface (for example, try to locate an MFM controller now, and an ISA bus slot to put it in).
280, tape is generally more stable than a HDD platter. It's still the standard for long term storage (that doesn't require quick access).
Except that there are far too many different tape formats, and you have to keep a working drive around to read them. Can you find something now to read 15 year old Irwin Accutrak tapes?
"Among the manufacturers that have done testing, there is consensus that, under recommended storage conditions, CD-R, DVD-R, and DVD+R discs should have a life expectancy of 100 to 200 years or more; CD-RW, DVD-RW, DVD+RW, and DVD-RAM discs should have a life expectancy of 25 years or more."
If you use archival quality media and store it properly. Home users aren't going to pay for that.
I suspect that the long term solution will be to keep copies in multiple places, and keep migrating data to new storage technologies as it becomes available. Or hand write everything on parchment and store it in a dry room in Syria. (I'm thinking Codex Sinaticus here. Look it up, it's fascinating.)