While spinning rust was destined to lose the majority of the market to flash, I think the hard disk companies accelerated the move with the SMR fiasco. It got me moving more things to SSDs sooner than I had planned.
I have noticed fewer and fewer SMR drives at top capacities lately, but they would be useful for read-dominated workloads provided the ingestion speeds are managed properly (I read somewhere they can be managed at a very low level where you’d be able to write directly to the SMR area for things like replacing a failed RAID unit, where you can write the SMR area at once)