The real reasons why it flopped
1. Nobody cares about a real Buzz Lightyear story. Not even kids
2. Nobody wants to see a Buzz movie without Tim Allen
3. Disney forcing woke shit as per usual turned a lot of people off
4. Chris Evans isn't a big draw outside of the MCU and politics are far left alienating part of the audience.
5. The trailers didn't make the story look very interesting.