In general, the root cause for SSD failure has been power cycling - usually in the cheaper ones with little emergency power fail protection. Ones from vendors like Toshiba, Samsung, Intel (the ones commonly used by PC manufacturers when you buy a preconfigured system) are more reliable. OEM vendors hate doing warranty replacements so they pick parts not likely to cause warranty repairs. (And manufacturers like Apple means even if 1 out of 100,000 fail, it becomes page 1 news).
Lifetime wise, few have actually worn out an SSD - about the only known ones are those that people purposely stress test to find out how long they can last. And the good news is that the Media Wear Indicator on them generally is very conservative - if you replace the SSD when the MWI indicates it's all worn out, you have really only gone about halfway. (It's not the indicator's fault - the indicator just shows that the number of guaranteed cycles have been exhausted, so it'll start using up spare blocks as they wear out). So when it claims to be worn out, all you need to do is buy a new one and replace it - you have plenty of time.
In general, you're far more likely to replace it because it's full rather than when it wears out.
Of course, if you use the SSD to hold videos inflight during editing, it might not be the best use of the SSD's capabilities since modern hard drives, especially in RAID configurations (RAID-0 is often used in video production because the needs are basically streaming video off the disk, which is perfectly suited for hard drives). Large linear reads are still better suited to hard drives, while small random reads (typical desktop usage, for example) are more suited to SSD's strengths.