@SamPatt Good post, including the clip of grandma's anecdote.
It would be a good idea to add a final step of burning the videos to M-disc. SSDs and spinning platter drives aren't reliable for long-term storage. You could use a tape drive if the file sizes are too large, but M-disc lasts longer and doesn't require pro hardware to read.
I use M-disc and I am sure the discs will stay safe for a long time. What I worry about are the drives! It seems the business of making drives is not profitable. So companies exit or reduce.
This is one reason I'd like to see a fully Open Source hardware+firmware optical drive. Probably best to start with CD-ROM, but DVD might also be possible. The optical and mechanical parts seem relatively simple, especially when you're not optimizing for minimum cost or minimum size (meaning you could use the original Philips-style swing-arm mechanism). From what I can tell, the most complicated part is the signal processing, and with modern hardware that looks practical to do in software. I'm not sure how far you could get with home-scale DIY construction, but CDs worked with late 70s technology, so at least that far should be possible.
That's better than nothing. Personally, I wouldn't consider it archival storage, so much as the possibility that 20 years from now Cloudflare (or a holding company) pays me $100 compensation for my lost data!
It would be a good idea to add a final step of burning the videos to M-disc. SSDs and spinning platter drives aren't reliable for long-term storage. You could use a tape drive if the file sizes are too large, but M-disc lasts longer and doesn't require pro hardware to read.