I have a NAS of 4x 8TB WD Red Pro; and a a desktop with 4x1 TB of nvME and 1TB of (grandfathered) SATA SSD.
For batch photo processing (i.e. lightroom) spinning disk is really sub-optimal. I'd rather have a 256GB or 512GB nvme and process batch by batch (and then offload to NAS), then a 8TB 7200 RPM HDD with all my photos.
To OPs point - depending on shooting style, you might easily do 300GB+ over a single wedding (primary + secondary shooter, 2 cameras each, 46MP, 14-bit uncompressed, spray-and-pray style).
Something that maybe spinning disks don't suffer from.
On the other hand, I would not trust either medium over extended period of time (years) personally - either dump to tape/optical, or keep making copies :).
Either way, I currently do not have a use case where either my SSDs or HDDs would be off for year or more.
(I do have a set of "off site" HDDs with my family which do stay unpowered for months before being exchanged)