Yeah it’s at the level of frequency where an ordinary user with one SD card is unlikely to have a problem, but if photography is your hobby it’s only a matter of time. In a rather informal poll conducted by Chelsea and Tony Northrup, they basically found that two thirds of the most active photographers had experienced at least one SD card failure. It basically was just a direct correlation with how many photographs you’ve taken.
Yeah but the practical write limit tests I’ve seen for SSDs (from ten years ago) put it well beyond what even a professional photographer would do. We’re talking SSDs that sustained constant writing of random data 24/7 and didn’t fail for more than a year. There’s just something about SD cards. As further “proof,” photographers don’t complain about their SSDs failing on them, even though those should have more write cycles than their SD cards.
SD cards don’t perform wear leveling while ssds do. This is why there are specific SD cards meant for surveillance cameras. They have additional wear levelling circuitry at the expense of speed.
So photographers who fill up their sd cards end up writing over the same spots repeatedly and wear them out.