Tape presents its own share of problems. If not strored in some very particular conditions, like temp, humidity, and others that I can't recall, they can stick to tbe adjacent layers, become brittle, curved, etc...

Yeah I believe tape is still king there. LTO is working on some 500+ TB tape for the future IIRC.

Strictly speaking, I think paper beats magnetic tape on longevity.

Unfortunately, it loses on data density.

Depends on the threat model and how long do you need the data.

Worked on a place long ago, that anything they needed to save offline from more than a few decades where stored in microfilm, the expectancy there where they would last 80 to 100 years.

Anything else was pretty much tape.

You also take in account the technology avaiability. The more complex is to use, harder will it be to reproduce in the future. Even with tapes, you might want to copy the data to another tape/recorder every decade or two, to keep it on par with the technology.

They were slc, so the charge ratio was much higher.

Mlc/tlc/qlc drives have to measure a current very precisely, up to 16 values of discrimination, any charge degredation doesn't change a 1 to a 0, but a 3 to a 2 to a 1 and given enough time, a zero.

Also smaller gate dielectric so more leakage.