I have nothing against the USA team or their players, but I think it's great for women's football (competition-wise without considering ratings) that they've been knocked out.
In terms of the continued progress of the sport which has already made tremendous strides, it was better for them not to win the tournament for a 3rd time in a row - I don't think it's great for any sport, men's or women's, for one team to win a quadrennial World Cup 3 times in a row. Plus they were clearly sub-standard and unimpressive at this tournament, and nowhere near as strong as they were in 2015 or 2019, so a scenario in which they still somehow scraped their way to another title playing like this wouldn't have been good look. It was like how it was crucial for other teams to challenge Lyon's dominance and topple them in the Champions League (which they won 6 times in 7 years), and likewise Germany's dominance in the European Championships (after they won it 6 times in a row).
Clearly overall numerous other teams have improved considerably, and therefore so has the depth in competition, which is great for the overall health of women's football.