When I count work related SD cars used by others, I have had a few failures.
If you freeze then and thaw them in cars, it is not good for them.
If you physically break them.
If you play with lard magnets like MRIs...
If you put something on them and then expect to retrieve it many many years from now.
As for the camera, I don't think I can wear out the SD cards. The slot, sure, the camera, sure, the cards.....no.
BTW, I am liking the micro-SD cards in converters in the camera.