Despite positive early reactions, Ridley Scott's new sci-fi movie debuts to his lowest Rotten Tomatoes score in 12 years