Modern Vespa

This was already addressed

I'd be more worried about SD slots disappearing than the life expectancy of SD cards.

I read a story few years ago, about a guy who tried to recover a file from a few year old tape backup. He had the tape, but the servers with the tape mechanism had been thrown away. He found a tape mechanism on Ebay. Then he found that the backup software was nowhere to be found. After weeks of working on the project the tape broke.

Yes, this is a genuine problem with digital archives. The gotchas lie not only in the longevity of the medium itself, but also the hardware and software necessary to read the media. I've used floppies, Zip disks, jaz disks, MO (magneto-optic) discs, CDs, DVDs, and countless different varieties of tape backup. I've also used many different kinds of hard drives with different connections (interfaces), as well as literally hundreds of USB thumb drives, PCMCIA Flash cards, Compact Flash cards, SD cards, and MicroSD cards.

CDs and DVDs have so far had the best equipment availability over the long haul, though the drives are rarely found on new computers anymore. They're still quite available, though, and the CD and DVD formats are well enough established that you stand a good chance of being able to read the data from them.

I expect SD card readers to stick around for a while yet -- SD cards (and microSD cards) are still in very common use in a wide variety of devices, so the obsolescence event horizon is still a ways out. Yes, it will eventually disappear.

As I said earlier, the key is to keep moving your archives to the New Best Thing, and in a timely manner. Long after the media has become obsolete is too late.

Forgot to mention.. I also have a fourth backup of everything locally to LTO 5 tapes!

Now that's excessive for personal usages, but if it floats your boat!

And then once you get it all stored, you need to worry about "format rot". This guy still has his Microsoft Word files from 1989, but no current version of that app will open them, making them as good as gone: https://www.scientificamerican.com/article/how-to-fight-format-rot/

There is also the question of what happens to your data when you kick the big bucket in the sky. Are all your 100 year old scanned photos, and digital media, accessible to people who might be interested? How long will they be accessible?

I have somewhere floppies with Word for Windows 1.0 on them. Unopened OEM package. I'd be glad to share.
Then the issue becomes finding floppy drives and, of course, an operating system that can run Word for Windows 1.0.
I can help again. I also have unopened OEM package with floppies containing DOS 6.0 and Windows 3.1.
Now the issue becomes finding PC's that can run DOS 6.0.
And hope that all those floppies still work.