Turning Red appears to be the worst, on a $250m budget (and probably similar for marketing, it took $20m[3].
[0] https://www.boxofficemojo.com/title/tt1979376
[1] https://www.boxofficemojo.com/title/tt2380307
Anyway, I’m much more interested in talking about what I thought you were originally: the qualitative “creative spark” that makes (or made) Pixar movies so special.
[1] https://www.boxofficemojo.com/chart/top_lifetime_gross/?area...
As other commenters have noted, Turning Red was the second most watched films on streaming in 2022, across all platforms (Luca was #9.)
Coco had a domestic theatrical release and was in theaters in over 50 other countries.
Luca did not get a domestic theatrical release (except for one week in one theater). Internationally it was in theaters in 20 countries. Similar for Turning Red except it was only in theaters in 17 countries.
Luca and to a lesser extent Turning Red did reasonably well in those countries where they were actually in theaters considering that it was during a pandemic when attendance was down. If they had been released in theaters in a non-pandemic year and in all the countries Coco was in they would have probably been at least $500m movies.
Luca was the most streamed movie of 2021 (10.6x10^9 minutes of streaming) (and it was #9 in 2022 with another 5x10^9 minutes) , and Turning Red was the second most streamed movie of 2022 (11.4x10^9 minutes) (#1 was Encanto at 27.4x10^9 minutes).
BTW, Encanto did get a domestic theater release and an international theater release in almost as many countries as Coco and yet only pulled in $256m worldwide. I think that's a pretty good illustration of how much the pandemic affected box office.
Happening to have a backup copy in your house 25 years ago doesn't justify your current role of being good at losing the company millions of dollars. Disney and Pixar have had a series of movies that in the main have had bad production and writing decisions attached to them, so even though the technical delivery (e.g. animation; music) and performances are generally very good, they are just boring. A lot of the spark seems to have gone.
If you watch the latest Disney or Pixar movies and compare it with something like the Arcane TV series, which is unbelievably beautifully animated and extremely well written, it's night and day. The talent that led Pixar has fizzled or been replaced over the years, and they can't pay people a fortune to lose them money forever.