Dumb question..
If I write big files e.g. movies to the drive, fill it, then delete entirely, fill it again and so on, is it the same thing they did?
Large sequential writes have a generally low write amplification, which means that the drive should last more; in theory at least, since they don't mention how many P/E cycles have been performed or what was the overall write amplification, so it's up to anybody's guess.
This is why I've often written that these kind of endurance tests are flawed and possibly misleading: the amount of data one can write for a certain number of program/erase cycles strongly depends on the workload type and testing conditions (random, sequential, continuous, is trim enabled, how much free space or overprovisioning space is there, etc) and can vary significantly. Luck counts too for SSD lifetime beyond the rated specification: the NAND in your SSD could be from a bad batch and last less than the average, or you might have some from a good batch, which could last more.
Then there's the data retention issue. When these drives fail after so many writes it's because essentially data retention has become so short that data cannot be reliably stored anymore, not even during active usage.
EDIT to clarify:
Is the drive going to fail after the said number of writes? I don't think that would take 18 months to do. That way a 128GB Samsung drive will take only 781 write cycles (for 100 TB) if I'm right. Anybody clarify my doubt?
I don't know where you took this data point from, but generally speaking the drive won't fail at 100TB if the P/E rating hasn't been exceeded, unless the SSD is defective. The max P/E rating itself isn't a failure threshold, but rather a safe limit telling that by exceeding it, the NAND might not be able to meet the 1 year of power-off data retention JEDEC specification anymore (among other parameters), which means that in practice, as these endurance tests show, you will be able to use it longer than that (how much longer exactly, depending on NAND quality, how good the SSD's ECC algorithms are, if the manufacturer has set fixed overusage limits, etc).