Super 8 is usually shot at either 18fps or 24fps. I’m going to assume it’s 18fps, as most home movies are.
There is a problem with just projecting the film on a screen and videotaping it.
Many people think of projectors as showing one frame, then blocking the light, advancing the film, then showing the next, but that’s not all there is to it. A projector like that would have an intolerable flicker. Rather than a one-bladed shutter, like this projector would be, most home movie projectors (and all film projectors in general) have three blades, so each frame is shown three times. The result is that the overall picture is darker, but flickering is no longer a problem.
So, while 18 distinct frames may be shown per second, what you’re actually seeing on the screen is 54 frames with lots of duplicates. This is no problem for you, but for a video camera, it is. A video camera records 60 fields per second (in North America, at least). 54 frames being shot 60 times, some of those times, the video camera is going to record a blank screen because it’s catching the projector’s shutter.
There are special projectors designed for transferring film to video, called telecine projectors, that don’t use three bladed shutters, but be prepared to spend as much as a $1000 on eBay for one. The next best method would be to get a variable speed projector, then adjust the speed until it matches the video camera and the flicker goes away–with a three bladed shutter, this would be at 20fps, since 20x3=60. If your film is silent and shot at 18fps, then speeding up to 20fps will be an almost imperceptible difference. If it’s sound, the pitch will be shifted a little upwards, but not too much.
You’ll need to use a video camera that you can manually adjust to get the best results. Set the shutter to 1/60, lock the gain at 0, focus on the screen, then turn on the projector with no film in it and hold up a medium gray card in the light to set the exposure.
I would advise against using a proper screen to transfer film. Just use a regular piece of bright white copy paper. The smaller the image, the brighter it will be, and video needs an awful lot of light to not look terrible. If the video contrast is bad–and it may be, contrast isn’t one of video’s strong suits–turn on a little ambient lighting in the room. The image will be flatter, but at least you’ll bring out some detail in the dark areas.
Super 8 equipment goes through phases on eBay–sometimes terribly overpriced, sometimes quite reasonable–but a variable speed projector should be easy enough to find on a $200 budget. I would also advise getting one that uses actual sprocket wheels to move the film and not just rubber rollers, since those are prone to scratching, especially if the rubber’s dried out. Clean it thoroughly with alcohol before running anything through it and pay particular attention to the film gate, unless you like dirt and hair jumping around on the screen. Get a newer model from the late 70s or 80s that uses a halogen lamp, it will be much easier to find cheap replacements when it burns out and it gives better color reproduction. Don’t be tricked by what someone might say on an eBay listing–a 1000w tungsten bulb isn’t any brighter than a 100w halogen one. Depending on how the projector’s reflector is made, it might be a good deal dimmer.
If the perfs are badly damaged and the film jitters in the projector, here’s a little trick: rewind the film onto a new reel so it’s tails-out and run it through the projector backwards. Damaged perfs are almost always only damaged on one side and the opposite one will be fine and jitter-free. Then, just reverse your video and flip the picture upside-down.
As for archiving, I agree completely with what has already been said here, worry about keeping the film itself in good condition. It will long outlast any video media you transfer it to. It wants to be kept in a cool, dry place, and it wouldn’t be a bad idea to drop a bit of camphor into each can to ward of vinegar syndrome. If it’s Fuji film, it’s on a polyester base and insusceptible, but Kodak and most other film is on an acetate base that can decompose if improperly stored (giving off a strong vinegar smell as it does, hence the name). If any of your film has gone vinegar already, keep it separate from the clean film. Though it’s never been proven that vinegar is contagious, common wisdom for the past 40 years is that it is. You can’t reverse vinegar syndrome, but camphor will stop it from progressing further.
Someone above said there are projectors that can show both 8mm (also called Regular 8 and Double 8) and Super 8. This is true, they’re called Dual 8 projectors, but the explanation given for the difference between 8mm and Super 8 is not true. Both have only one row of perfs, but 8mm has large 16mm-style squarish perfs, whereas Super 8 uses much thinner rectangular perfs, leaving more room for a larger image. Both can be sound stripped with magnetic tape, and Super 8 can also have an optical sound track, but these a pretty rare, mostly just being used for in-flight movies. There are some excellent Dual 8 projectors, like the Eumig 810D, but on the whole, Dual 8 projectors are crap and very bad on film.