Exploring the Martian frontier was a cinematic flop in 2000 with Red Planet and Mission to Mars Discover why these sci-fi films failed both critically and financially