> My advice is to have "some fair number" of SD cards and when you are done with the card in the camera, put it aside and install another card that hasn't been used in aw

Yeah, a kind of rotating workflow seems necessary when you doing professional camera stuff.

Of course, something like this can always happen; however, it's just as likely that an SD card will fail at some point.

The camera should record redundantly, and many semi-pro cameras already do this if you want them to. Then you can leave the second card untouched and have a spare one and rotate only the spares.