Surely it's not hard to fare better than TLJ? The prequels were bad because there was so much CGI and George was pish at writting scripts, but TLJ was bad because it changed so much and had some horrendous flaws. I get yer man wanted to try and take the trilogy in a different direction after the very safe effort of TFA, but he just made a hash of it. Add in the Liberal PC nonsense and the film was a disaster.
Disney wanted a film people would like and fans would watch over and over, so they could make money from it. The fact it was so divisive will have severely limited it's takings. It also seemed to harm Solo. I guess that could just be a case of too many SW fans for the casual fan (of which we are not one) we'll never know. But the amount of hate generated by TLJ could not have helped.