Do you not realize that, in this day and age, the box office numbers of a film's original release can be basically irrelevant to its level of success?
Hocus Pocus absolutely bombed in theaters in 1993. A few days ago, the teaser for its sequel got 43 million views in the first 24 hours on Disney+ alone, never mind additional millions across Youtube and social media. It beat out viewership for The Mandalorian and The Book of Boba Fett. But by your chosen metrics, that property should be considered dead.
The Princess and the Frog, and Tiana in particular, have proven to have legs beyond the initial box office release for the movie. She's highly sought after in the parks, moves merchandise, and offers representation to part of Disney's viewership that is historically excluded throughout the rest of their canon. The movie's performance in at-home releases and streaming numbers tell a story that the box office, for a number of reasons, does not.