This is the kind of discussion i'm here for. Thanks everyone! I didn't know SD and micro SD cards where this unreliable but i always use them for short term stuff or content that is backed up somewhere else so i think i'm good.
They aren't that unreliable FWIW. Obviously, it should not be your only copy of media, but I have microSD cards that are still readable with data intact even 10, 11, or more years later.
If you buy quality microSD cards, expect them to last a long time.
I feel it's worth mentioning the application of them also factors into their longevity.
Good quality SD card holding some documents and random files? Yeah probably 10+ years. Good quality SD card being used in a dashcam, constant writes? I'm replacing my good SD card after about ~2 years of service because its showing signs of failure.