I've never had an RPi corrupt an SD card, but I had one (running pi-hole) wear out a card over the course of about six months. It was pretty easy to get everything back up and running (it needed a new card with the most recent version of the default OS package), and I was able to resolve the situation long-term by using log2ram to space out writes to the SD card (at the risk of losing a day's worth of logs).