Watching The Rise of Skywalker for a second time definitely made me enjoy it more for what it is and realise I think the best comparison for it is Sam Raimi’s Spider Man 3. Both suffered from being overstuffed, both messed with established lore to certain degrees, had studio interference in production, had uncomfortable endings, and yet both can be fun and cringeworthy at the same time. I’d say Spider Man 3 is slightly better though.
The Rise of Skywalker is now ranked eighth in my rankings just ahead of The Force Awakens and right below The Last Jedi.