'Red Planet' is another movie that came out within three or four years of 'Soldier.' It was a great time for an abundance of sci-fi movies, but the law of supply and demand tell us that abundance makes for low profits. This movie is about a crew sent to Mars to try to colonize it. Why would anyone ever do that? Because Earth is dying. Maybe this movie would do better today when everyone can relate to it a lot more. Maybe we can all go to Mars when the Earth gets too hot.
Movies like this usually lose money because they are so expensive to make. A decent amount of people might come to see it, but when you're spending millions on effects, you need an army to show up just to break even.