In order to unlock the ending FMV, you must beat the game in 007 Mode. If you beat it on Agent, you just go back to the mission select screen.