I'm, gonna have to disagree. As we've seen, in all those things that don't have straight white male as the lead, it was still generally the white male showing up and watching the movie. Look at The Marvels. Who did those people blame for it's failure? White males. Who show up the most for the movie? White males. Break down of their sexual identity isn't given, but odds are they're straight.
The reason these things are failing, isn't because the lead isn't a straight white male. One, it's killing off beloved characters and for a large part of that fan base, it was characters that had multiple stories in other forms.
Yes, George said the books were only canon until a movie said otherwise. However, what did the movies do? Killed off the popular characters and turned them into crap characters. There was no reason to kill Luke, Leia and Han. There was no reason to ruin Luke. This was done because he was a white male character and it's not helping new fans like those old characters either. I know a few people who like Star Wars, but were introduced later and they go "Screw Luke! Look what he did to Grogu!" Something EU Luke never would've done. 😛
The second issue is people aren't enjoying the story. I know watching Ahsoka, I was so disappointed with it's fight scenes it made me a bit meh on it. Ahsoka was so bad ass in the animations and then they turned her into a fighter the likes of Obi-Wan in Episode 4 😛 None of the movement she had. Didn't even feel close to the prequel era fights in which she was a part of.