This is the most clear-cut kids movie Star Wars has put out, other than the animated Clone Wars, since The Phantom Menace.
I don't think any new fans will be made by it. Boys love Mando, all kids that have seen him love Grogu. It will sell a s*ton of merchandise to offset the lackluster box office, but will keep a key demographic - kids who want material possessions - locked in for another couple of years.
I'm hopeful Starfighter will be excellent. I would be interested in an older/wiser Rey movie, but more Finn is not entertaining. I can only hear him scream or yell Woooo so many times.
It certainly sounds like they're balking or have already pulled the plug on the Filoni-verse finale. I think they could salvage that, but it would be hugely expensive because you would need at least 2 of the big 3 in it - Luke & Han, with Chewie and the droids, but that's de-aging Hamill and Ford or going straight CG throughout and having to either be obtuse or controversial about Leia.
Personally, I would love a 2-part knockoff of Zahn's Heir to the Empire books featuring Thrawn, Pelleaon, and what's left of the empire vs. the nascent New Republic. I'd even be down for something along the lines of the Joruus Cbaoth plot line that hooks Luke in the books. Hell if you wanted to, you could have Sam Jackson back as a clone of Mace Windu that the Emperor made after Anakin cut his hand off to make it all relevant, because Mace Clone-du (thank you) could theoretically talk to Luke about Yoda/Obi-Wan/Anakin.
Of course, the real blockbuster is just sitting there begging to be made. The 5 of us who bang the drum for the KOTOR movie every couple of years could write it no problem. Movies and TV shows based on video games have been huge the last few years. Star Wars a few thousand years ago with everything you want built into - Mandalorians, Jedi, Sith, wookie, twileks, tatooine, a whole underwater planet, Korriban, secret identiies, a band of misfits, it's so frustrating that they won't take this amazing property and put it on the big screen.