I agree, and I mean... there are a lot of theories and reasons for why the movie wasn't the box office smash it was expected to be.
- Marketing campaign did the movie dirty.
- Having the word 'Princess' in the title meant a chunk of the market (little boys) did not want to attend (I hate gendered norms, this is an unfortunate and dumb reason, but also why you see titles since like Tangled, Frozen, Encanto, etc.)
- Disney had not made a big fully animated musical movie in a long time, and the market hadn't fully swung back yet to enjoying musicals (just a subjective opinion on my part, Enchanted did better in 2007, but was a mix of live action/animation, and was sort of a parody).
- and as evident by what still happens these days when Star Wars includes BIPOC Women in the line up... I am sure in 2009 part of this also had to do with it being centred around a Black woman... Screw racism.
Needless to say, a lot of factors may have or did contribute to the box office performance, but this doesn't mean it is NOT a success today, and certainly doesn't preclude it from being used in a ride.