I do hope that Palpatine’s return is written really well for people to accept his return and role in The Rise of Skywalker. As someone who generally does not like fan service, I do trust Lucasfilm with what they’ve been doing with the sequel trilogy.
I think the significance of Palpatine is greatly overstated. It’s possible that he’s just be part of a Sith artifact macguffin that’s in the Death Star wreckage.