I’m glad you recognize the comedy and irony in it as well. I touched on that quite a while ago on this page. I love the idea that Palpatine thought he has such a mastery of the Force that he could influence its own creations to serve his own will. That didn’t work out well for him the first time, yet he tries it again! Really funny stuff.
Yeah. Perhaps Palpatine would have won if he’d only realised that Rey/Kylo were his joint heir, and sat them on a double-width throne together. Perhaps again it’s the Will of the Force getting one over on Palpatine - it knows the Sith are insistent on one master/one apprentice, so it made one that is two so the Sith would never think to permit the coexistence of both, and set up a situation where his spirit wouldn’t be able to inhabit the heir since it’s, y’know, two bodies.