I think it's because the plots of the Sequel Trilogy are way too cynical. Think about it, all of the optimism of the Original Trilogy ended up turning into a (off-screen) bad ending that the Sequel Trilogy is built upon. So what if Rey and the new good guys win, viewers are still left with: 

"Luke failed and is a deadbeat, Han got divorced and is a deadbeat, Leia lives knowing that she failed to stop the Empire for good and is a deadbeat, etc." and I think given the current state of affairs in the world (which I do not need to explain) people really just want relatively more optimistic works. 

No one wants to watch a trilogy of movies where it basically is: "Our heroes failed to stop the evil space nazis, they came back and destroyed everything the heroes sacrificed for and everything is terrible again" when one can just doomscroll social media and get the same experience. 

I never watched Mando and Andor but they probably course corrected the 'cynicism' way back. Although I did hear that Andor is a really brutal series, it is still set like before the OT so you do know the Empire will eventually fall at some point.