SD cards are ephemeral. All SD cards. SanDisk SD cards are popular, so that may bias your perception.
There are some SD cards that are better than others. The best cost much more and are often slower. They usually have the word "Endurance" in the model name. Like "Max Endurance" or "Pro Endurance".
There is a very strong correlation between low price and poor endurance. And a slightly weaker correlation between high price and good endurance.
Saving stuff to a SD card is what especially cause it to wear out. Reading stuff is not quite as bad. Heat makes a SD card fail extra fast.
It is good practice to offload photos to a PC, or the cloud, as soon as possible.