I think the main issue why my anticipation for Episode IX is so much lower now is that this trilogy lacks what SW has always had, even in the prequels, and that's a strong villain.
Snoke started to fill that role in TLJ before he got offed, but Kylo Ren didn't get anything to even begin to make him able to fill those shoes, and he's already been soundly defeated so that's not something I have to long to see either. That pretty much just leaves a turn to the light side as interesting development, but I think he's in entirely the wrong situation to make that work as well as it can.
Hux also doesn't feel very worthy of his position, not looking particularly confident or competent, so the New Order kind of feels like it's now run by two relatively weak people.
The New Order still has all their assets but the leadership still makes it look kind of weak (although the Resistance is of course all but gone).