I'm not talking about the market segments where tape or RAM dominate (and would continue to dominate). I think the use cases you are imagining for spinning rust are a tiny portion of the market for storage, or simply do not exist. For example:
It's hard to actually rewrite spinning rust 2000 times a year. That's exceeding 100% utilization with completely optimal sequential write pattern on 7200 RPM drives. Say you can write 200 MB/s continuously[0]. That's about 6 PB/year. With a 6 TB harddrive, that's only 1000 full overwrites a year.
Maybe 10k or 15k RPM drives can overwrite 2000 times a year, but those have vastly higher cost than 7200 RPM drives. At some point, you just overprovision the flash enough to bring the number of required overwrites down, and it's still cheaper than 10-15k RPM drives.
[0]: Approximately average for enterprise drives: http://www.tomsitpro.com/articles/enterprise-hdd-testing,2-8...