SSDs don´t die because of Tbw´s (terrabytes written). They die because of too many iops (OS-usage). My stone-old Intel-ssd says, it can handle 1 mio hours before it will fail.This means, it would last 100 years, assuming one year has approx. 10k hours.
However do notice: this SSD was produced in 55nm or 65nm 10 years ago, it was a high-quality product (which was very expensive for just 80/160 gbytes of storage). And it´s iops is limited to 20-30k read/write @4k sectors.
So SSDs have become much faster. But they will also die much younger today. E.g. i haven´t seen a single m.2-SSD yet, which survived 2 years, assuming it was used daily for at least 3 hours.
On the package you also no longer will find 1 mio hours mtbf. And today´s ssds are much-cheaper (because much lower quality) produced.
Today´s SSDs achieve about 500k iops. But they also thermally throttle.
Thermal throttling doesn´t help the ssd to survive longer than 2-3 years though.
SSDs now die because of same reasons why cpus die = electron-migration, guys! Electrons wander through the SSD´s cpu´s & transistors & "cuts" away some material, takes it with them & then produces e.g. a short-cut. And the smaller your nm-process is (e.g. 14nm) the faster your cpu or SSD is showing signs of death.
I collected many SSDs over the years: Many from Intel. Some from Kingston, Supertalent & even from Samsung.
I think the older they are, the longer they´ll survive. The slower they are, the longer your SSD´s life will be prolongued.
Finally this means all "TBWs" is just PR. It means TBW won´t dictate how long your SSD will work, but just the memory-cells. SSDs are small multicore-cpu-equipped computers now though (since 8 years). And we all know, that today, under heavy loads, no cpu can achieve stable operation for 8 years any longer...
Today´s SSDs die because of the controller´s death. If you don´t use it daily, you will prolongue the controller´s life.