So, in light of the saga films ending, where does Star Wars go from here? I think Kathleen Kennedy has to go. I think, despite how you might feel about the films individually, the saga trilogy as a whole is a terrible mess. It's clear there was a total lack of vision and KK gave the directors too much power. I get that maybe they were trying to do what the OT did by having different directors for every film, but what she/they missed was Lucas was still creatively calling the shots in the OT for all the films. It was painfully obvious a unifying vision was missing. On top of that many of the Star wars films under her direction have had massive production issues behind the scenes, some evident in the final product, some not. I wont even get in to how she set up the story group just to marginalize them during the making of the saga films.
The Star Wars franchise is more than strong enough to survive some blunders, and if Mando is any indication they just might kill it in the streaming realm. But still, I don't see how she can remain at the helm of the Star Wars movies, as it is clear leadership from the top has been a problem.
I think now that the Skywalker saga is done, I would anticipate them maybe doing knights of the old republic type of stuff. Personally, I think it would be interesting to see films on the creation of the Jedi order, the Jedi schism (creation of the Sith), the Mandalorian wars, and potentially the creation of the new republican (which we see fall a part in episode 1-3). There are a lot of years of history between all of that which is ripe for making new films. Personally, I would love to see an army of Jedi fighting an army of Sith.
I haven't seen episode 9 yet, but I agree that Kathleen Kennedy gave too much vision and control to the directors. While the first six films of the trilogy had different directors, as you said, Lucas still created the story and had the vision for it. While the prequels had bad acting and dialog in it, the overall story arc was good. The lack of a story arc hurt the latest trilogy (even through I haven't seen episode 9, based on 7 and 8, I feel confident this will continue in to 9).
Regarding the story arc, what really baffles me is that with the success Marvel was having at the time Disney purchased LucasFilm, you would have thought they would have planned out the trilogy and anthology films better and be connected in some way. I was confident at the time they would have done this, but for some stupid reason, they didn't. It's just mind boggling how stupid management can be sometimes.