Earlier quoted context omitted.
Are there other computers that run off of SD cards long term successfully that are not Raspberry Pi’s?
I work on embedded linux machines that go a decade plus in active use with micro sd cards, it's not a problem at all
I've just scrapped a large PBX which had a whopping 8MB SD card in it. Its 486 processor booted Linux off the SD card, it wrote CDRs to the SD card, it served said CDRs up over a web interface off it, it saved its logs to the card, and all the other day-to-day chatter of a running system.
It was installed pretty much 20 years ago. The date sticker on the SD card shows that it was replaced 18 years ago, presumably as part of an upgrade.