Here’s from someone who only bought the supposedly highest recommended ones and had several failures before I switched to usb. Maybe roughly average 10-20% failure/ year uptime for something that has heavy log writing?
A thing people tend to forget is temperature. Keep them cool and they have higher chances of surviving longer.
On my network of random Pis and other stuff, I use only high-endurance SD cards which can withstand lots of writes have durability much closer to SSDs.