The funny thing to my mind is... All of the movies the OP mentions are decent movies. Well, okay... I haven't seen The Lone Ranger, and I'm willing to take the majority of critics at their word and presume I should keep it that way. But Prince of Persia, Tron Legacy, Hidalgo, John Carter- sure, they all have their flaws, but I'd still argue the least of them (which to my taste would probably be Legacy) still has moments of greatness, a striking and unique visual style, and remains a mostly cohesive experience.
For comparison, PoTC: On Stranger Tides is such a godawful shambles of a film that I went home and wrote five and a half pages of rant about the various depths, breadths and heights of its stupidity. (Don't get me started- please.) Yet that movie made over a billion dollars in worldwide box office, which tends to mean that people told their friends and families to go see it and/or went to see it themselves more than once.
(And Identity Thief made five times its budget...! *twitch* *twitch*... But I digress.)
Clearly, I am not an effective predictor of box office performance, and should perhaps disqualify myself from the conversation if we're talking about successful movies as opposed to the more subjective notion of good movies. Though it appears that, somewhat surprisingly, all of the above made back at least their budgets once worldwide gross was taken into account.
Now, four of the movies- Lone Ranger very much included- were dependent on franchises that perhaps did not possess quite the mass appeal they might have seemed to in the pitch meeting. If you didn't know PoP from its long legacy of games, you were stuck with a movie taking place in the Middle East with all characters playing the part of Middle Easterners (not exactly Middle America's cup of tea); if you did know the games, you were left wondering if it would fail like so many video game-based movies before it. Tron came out in 1982. John Carter is Tarzan's much, much, much less well-known brother. Hidalgo is a cowboy movie largely without cowboys, a race movie without a series of up and down races to raise tension. And my only exposure to The Lone Ranger was a Saturday morning cartoon I do not remember with an excess of fondness.
Aside from the ride, the Pirates franchise has some pretty well-known actors. Bloom was flying high after LotR, Depp had been carrying quirky roles forever, and Knightley was gaining notice for Bend it Like Beckham. It was a genre that hadn't been over-represented lately but was easy to understand and immerse within. It had strong action set-pieces, both a younger and an older leading man to draw in moviegoers, and a script that wasn't entirely witless. It had, in short, a variety of legs to stand on.
By comparison, what were any of those other five movies relying on? Yeah, some good actors, certainly. But in crowded movie seasons (Tron and Prince), audiences had other options; in March, Hidalgo and Carter were both pretty easy to simply overlook.
It seems like Disney can bring together the budgets, screenwriters, directors, and actors to make a movie that ought to be a breakaway smash. But unusually, it may be that they actually could stand to do more market research, barring another multi-tiered win like the Pirates series. It seems like they never asked who would want to see a Lone Ranger movie, or what they'd want to see in it if they did. They just assumed it would be Pirates with trains rather than boats.