I'm running a batch of SBCs which boot from SD cards as home or forgettable servers. None of them died due to SD card failure yet. A good SD card with a little optimization keeps the flash media wear out at bay.
Like writing logs to RAM and syncing back to disk daily or only on reboots/shutdowns, keeping high-write applications on a USB drive and providing the biggest cache possible by slimming down the OS memory footprint.
This two things reduce the hits to SD card substantially.