I prefer using more than one external memory cards fot the pictures that i shoot in the field.
I am much more comfortable one more less-capacity cards than one “supersize” one.
There is no scientific basis showing a greater tendency to damage the “bigger” cards.
This is just my tribal practice.
However, it is true that memory cards (CF, SD, Micro-SD) can be damaged and compromise (or limit) access to recorded data.
If you are on the field and you bet everything on a 128GB card, in case of damage you risk losing all the work so far.
And maybe you don’t even have a spre card to allow you to keep working.
When I make an aerial photogrammetric survey of large areas, I often change the memory card.
How i choose it, depends on the type of photo i shot, where i had my take-offs, the time of day, and things like that.
I am fine recordins nadiral pictures in one card, the oblique ones in another, and other angled photos (if needed) in another one.
If i shoot panoramas too i’ll go with a fourth one!
It’s my way to go.
And sometimes it’s hard to follow the plan.
But if i have the chance i go with that.
If something goes wrong, I lose only one dataset of images instead of all the work.