I hear you. "Thor: Love and Thunder" grossed far more overseas than in the US. "Avatar 2" is also not doing well domestically. However, both got bad reviews and word of mouth. IMHO, "Avatar 2" sucked except for the amazing CG. I've told all my friends to avoid it.
On the other hand, "Top Gun", "Wakanda Forever" "Doctor Strange 2" and "Minions" all did extremely well domestically. Clearly millions of Americans want to see blockbusters in a theater.
At the end of the day, I think that the studios are going to reevaluate how much they spend on blockbusters and whether to make one or not. An MCU film no longer means an almost guaranteed $1B gross. Disney is now putting more focus on TV Series than movies.