Critical failure vs box office failure are two different things. It was coming off a weak sequel. Cost 275 mill to make which the general rule of thumb is double that for marketing and it made 500 mill on top of that. Every single studio would have taken a "failure" that made a billion dollars. Comparing it to Endgame is ridiculous. That was the summation of 21 preceeding movies. Star Wars has 9 mainline and 2 spinoff films. Regardless this is off topic; we can discuss this elsewhere. Your opinion is clear, so is mine. I disagree with your assertion.
No, comparing it to Endgame is not ridiculous. TROS was the “summation” of 40+ years of stories... 40+ years in the making for the saga to end.... the most popular influential pop culture franchise of all time... and it fell flat.