In case it wasn't obvious from the thread that HELP_The E linked to, the easiest way by far is to use Turey's Freespace Open installer.
The link for the download is at [url=www.fsoinstaller.com]www.fsoinstaller.com[/url], and the installer for Windows can be downloaded directly from
http://www.fsoinstaller.com/files/installer/FreeSpaceOpenInstaller.zip Be warned that this might download up to 5GB of content depending on what options you select, but this installer will do everything.
Once you're done and everything is downloaded, fire up "launcher.exe" from your Freespace directory. Choose the "Mod" tab, then load either the "fsport-mediavps" (freespace 1) or "mediavps" (freespace 2). Then hit "run" and you're good to go!
Note: I needed to move the FS1 movies that were automatically copied by the Freespace 1 installer before they would play - I had to put them into \Freespace 2\fsport\data\movies and I think they were in \fsport\movies.