No need is very different from an active detriment which was what I was arguing that it isn't. Our OP was talking about partitioning into data and system which is exactly a housekeeping partitioning scheme. It also serves to facilitate multi-boot environments, though granted unless both systems are versions of macOS, the APFS logical partitioning wouldn't then be the trick.
Write speeds are better, the drive will have a longer endurance rating, i.e you'll be able to write more data to it before it's expected to die. Whether that's worth it is a different story, but there are reasons.
Regarding failure rates that's both true and false. If the objective is cold storage, SSDs will never really catch on since they fail much sooner than hard drives or tape. But yes, under the discussed circumstances, sure.
The internal SSD will likely outlive the other components, like the CPU or PSU. Or maybe not, but it'll at the very least (assuming no spectacular conditions), your SSD will last a very, very long time.
You mention multi-boot which is not all that typical and certainly has nothing to do with the scenario mentioned of separation of OS and other items on the drive. There is no real advantage to separating out on an SSD as originally explained was a goal. If people remember things such as SCSI ASPI tricks, then you have a good case for isolating on the drive some areas that are rarely addressed, areas that are intensive in reads and writes and more. If one was doing "de-frag" (not a practice common to SSD as typical housekeeping), then there are games to be played on how data is placed on a disk and more. We also don't worry about data on inner tracks or outer tracks. This is yesterday's news. SSD drives are not your father's MFM / RLL drives.