USB and Firewire are very different. You can't convert from one to the other just by taking a USB connector and a Firewire connector and connecting a few wires. It won't work, and you can even cross-connect the wires in a way that would damage connected equipment.
This hasn't prevented vendors from selling bogus "USB to Firewire" adapters that consist of a USB-A connector, and a Firewire connector, glued together in this way. And online marketplace sites have been very bad about not taking down "marketplace" listings for these fraudulent and potentially dangerous adapters.
I found a manual on the Sony UK site for a DCR-HC24E. It says that the DCR-HC24E comes with a USB cable. It appears that cable would have been a USB-A 2.0 to USB 2.0 Mini-B cable. There is no mention of any FireWire / IEEE 1394 / iLink to USB cable shipping with that camera.
Sony – Handycam Operating Guide – DCR-H23E/HC24E/HC26E/HC35E
I would take that "USB to FireWire" cable and stick it in an large envelope marked "DO NOT USE."
Unfortunately, your options for importing digital video from that camera are going to be limited. After failing to ever come out with a Thunderbolt 3 to Firewire 800 adapter, Apple discontinued the Thunderbolt 1 to Firewire 800 one – which people had been daisy-chaining with the Thunderbolt 3-to-2 adapter to make a connection. I don't know of any Thunderbolt 3 or 4 docks that have Firewire ports, either.
If you can't find the right equipment to make a proper Firewire connection, you might wind up having to get a video digitizer designed for VCRs, and use it to pull in video and audio from your camcorder's analog outputs.
