Honestly, SSD even with mlc or tlc seems fine with lifespan, despite all the writing involved. I've no doubt It won't be a problem on a console...
Almost all your operations on a console are reads, at least as things currently stand. You install once, but may end up reading that data hundreds or thousands of times. Games saves are typically very small.
A good SSD has an SLC cache with hundreds or thousands of times the write endurance of QLC (and better performance).
An SLC cache might also be modified with a partition for saves, or a section of scratchpad for games to use at will.
My hope would actually be for a decent chunk of SLC under developer control, and a larger section of generalised TLC or QLC that was a more automatic cache, perhaps taking hints from the game about what to cache, and in what order.