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.