The kind of media I don’t have backup of is from my Handycam tapes since they no longer make the software and I don’t know how to digitize them in any other way.

Do this if desperate, but see below first: Magnetic tape cassettes? Are they standard? Then just stick them in an audio player and record the signal— Or actually, they’re probably 8mm, or DV, or something— So then rip the reader head out of an audio player, scroll through the tape at a constant rate, and digitize that signal (for as many tracks as needed). Don’t do anything silly, like using too much force or sticking too strong a magnet next to them, of course. As long as you’ve got the signal, you can worry about decoding it later if you lose the originals— Get some nerdy college student to figure it out, or wait for someone else with the same problem to post their GIT repository.

Easier: Check if the Internet Archive has a copy of the software. It looks like they have quite a few Sony Handycam CDROMs. Maybe you’ll find a compatible model. Run it on an old Windows VM or computer if you need. “No longer make the software” sounds odd; Software like that is made once and then distributed.

(Or: Presumably you can still watch the tapes? Does the camera not have video output that you pass through some sort of capture box? — Though that of course would be lossy.)

Or: Wikipedia suggests the “Handycam” brand was used for multiple format standards, like “Video8” or “Hi8” or whatever. So just search Nile.com (or your personal favourite exploitation-powered online storefront) for “NameOfFormat Digitizer”, and wait for the order to to arrive. Here’s a couple articles from the first search results: IndieWire, VHSConverters. Here’s a machine that supports a couple formats, and has licensed a very reputable brand KodakPhotoPlus. And here’s a service that will apparently do it for you: LegacyBox. — Pricey, maybe, but how much time and money are you already spending, and how much are the tapes worth to you?