Hard to say why some otherwise decent movies bomb, I mean Rain Man was a hit and what the fuck does that even mean?
However Disney's assumption that there was an existing audience for a John Carter adaptation was fatal.
Post-Walt's death Disney has always had a problem with science fiction. The Black Hole, Tron and Tomorrowland all bombed.