I think you’re confusing your lack of knowledge of the commonality of this with the assumption that it is rare. I don’t know anyone who expects a Pi with SD to last more than a year. And the “solution” is always to buy the more expensive SD cards that last longer. And that’s not a solution. It’s time for Raspberry to give up the SD card for a real form factor. I can get a 120gb nvme that’ll likely never fail in my lifetime of Pi usage, or carry two mirrored SD cards for the inevitable failure that’ll happen when I can’t re-image a machine (like in flight - https://stratux.me)