The 32GB card I have running in the Pi that often hosts www.pidramble.com has been running on a Pi 2, Pi 3, Pi 3 B+, and now Pi 4 for almost four years and has

The 32GB card I have running in the Pi that often hosts www.pidramble.com has been running on a Pi 2, Pi 3, Pi 3 B+, and now Pi 4 for almost four years and has not had any corruption issues. I also have had a number of other Pis using the Samsung Evo+ and SanDisk extreme cards, many running for one to two years (some doing logging, others saving time-lapse pictures, uploading in batch to an FTP share, then saving more), and have also never encountered a corruption. I think it has a lot more to do with the power supply than the card itself (as long as you're using a SanDisk, Sony, Samsung, etc. and not some no-name card). I think the endurance cards have a little better caching mechanism built into the flash controller itself, so they can kind of paper over flaky power supply issues. So yes, it is definitely better to use endurance class cards. But in my experience, I have not encountered an issue using the typical consumer-grade cards.