SSDs wear out based on writes, typically expressed as either TBW (terabytes written) or DWPD (drive writes per day) - so the more that you write to them, the faster they will burn out. The more writes a drive can handle, the more expensive it tends to be.
Spinning disks, on the other hand, die based on mechanical failure - you can write the daylights out of them, and they'll just happily carry on until their bearings seize or they receive some other "mechanical incentive to fail" - like a large object falling on your computer, or your computer itself being the large object doing the falling.
Video archival storage generally is just fine on HDDs, as it's "large sequential file access" for the archive reads and writes - if you're talking about doing work on the live files (NLE) I usually suggest doing your work on local storage (high-quality NVMe will give you several GB/s of throughput) and performing regular backup copies to cheap spinning disk (locally or in TrueNAS)
What size of files, and what kind of transfer speed are you usually seeing? I imagine a large array of spinning disks with a point-to-point 10GbE network and sufficient local SSD would be a better overall setup.
