The recent DC Comics movies are a good counter to your "money over all" claim. Wonder Woman was a knock-out commercial and critical success, with both critics and audiences. However, Man of Steel, Batman v Superman, and Justice League were all met with decidedly mixed reactions from critics and movie-goers. But ALL of the films made crap-tons of money. If money were all, there would be no problem. But, Warner Brothers has been working damage control for years now, and has tried (unsuccessfully so far) to right the ship and bring the whole franchise up to the quality of Wonder Woman.
Hollywood films DO have to make money, as they cost so much money to produce and the studios want to make their investments back with lots of profit they can hide in their accounting books. There is very much a level of "this is business". However, movies are also art, and (most of) the folks making them . . . studio execs, producers, directors . . . consider themselves artists and want to create art that people respond to positively, emotionally . . . films that resonate AND rake in the cash.
Jack in the Beanstalk wasn't a bad film, many enjoyed it, but 20 years from now you will likely forget all about it. John Carter was (of course) based on a beloved property, but one most audiences are unfamiliar with, and again, not really a bad film, but . . . . The DC movies are also not bad, but the DC comics fandom is wide and passionate, and the films made too many missteps with beloved characters. The same could be said of the Star Wars prequels and the current Star Wars sequels. They aren't bad films, but the original trilogy, flawed as it was, has taken on almost biblical status.
Of course, another factor, specially with long-standing beloved properties like Star Wars and DC Comics, is that hardcore fans can get nitpicky and entitled, making loud, angry criticisms that leave others scratching their heads in confusion. Hardcore Star Wars fans decided to hate the prequels, but yet the kids who grew up with those movies often love them. The same is happening, although with less nerdrage, with the new Star Wars films. Young people new to the franchise don't have the same reverence for the OT, and often enjoy the newer films. I personally love the DC characters, but didn't grow up reading comics, so I take less umbrage with the new DC films than some of my pals who've been reading comics since they were in diapers.
All of this is generalizing, of course, and YMMV. Money is important with studio films, but it is hardly the only factor, or necessarily the overriding factor. What makes a film "good" or a "success" is complicated, with profit being one important piece of the puzzle.