Looks like there are some kits for this on Amazon - Here. or If you can come up with a mini DV camcorder (eBay, 2nd hand, family) or some way to play the mini DV tape, then you will only need the RCA capture card to convert the analog to digital.
On the Mac, I think you can use iMovie or QuickTime to record the playback (it has been a while since I used either so this could be incorrect). If those don't work, you can try VLC player or OBS to record the capture card. If you have to go this route for software, think of this as just recording a USB webcam.