As someone who services client SANs, I could not disagree harder. I cannot count how many times I have seen some site suffer a poweroff and then half the spinners don't power back up even though the health checks were previously green checkmarks across the board. Most folks plan their RAID for 1 or 2 failures, not 6!
If you want to archive at rest, bluray/dvd or tape in good climate controlled storage is the only way to do it. Your HDD will spontaneously die simply because it is a moving part well before a comparative SSD reaches the write-limit.
I agree on the idea of BD/DVD/tape in a well-kept environment for good long term storage. When storing on optical media you'll want to be sure to get an archive-grade storage medium like M-DISC.
I've had DVD archives become unreadable a few years later and stopped using them. Is your argument that drives that can read them will get better faster than the media degrades?
If you want to archive at rest, bluray/dvd or tape in good climate controlled storage is the only way to do it. Your HDD will spontaneously die simply because it is a moving part well before a comparative SSD reaches the write-limit.