Sorry to hear about the footage, but can you see the .trashes file?
If you can, it may be as simple as dragging those files across to the Mac . . … if not, you’ll need to find a way to “see” the hidden files on your mac (I have an applescript which will do this, but there’s plenty out there - just use Google) - then try the same drag method.
If they’re not visible in the .trashes file, chances are you’re buggered!
The only other thing I can suggest, is - once you can see the hidden files, there are sometimes other files created on the card by the Mac OS, try checking each folder using (cmd+i) to see where the larger files might be located, then open and see if your video is in there.
That’s all I have I’m afraid!