I don’t like the cloning idea because it just raises an inevitable question at the end of TROS: is he really dead? Surely he must have a plan Z - another load of clone bodies somewhere! Bleh. I know canonically his decrepit form in TROS is because the cloning was imperfect or whatever, but when I first saw the movie I just presumed he looked like a corpse because he literally was a corpse being Darth Sion’d back to “life”. The Frankenstein imagery of the big claw also compounded this. Luckily, TROS is a great movie for headcanon since most of the plot around Palpatine is exclusive to the novelisation, so I can continue to gleefully ignore whatever I don’t like until Filoni or Soule or someone redeems it.
I don’t think that question is much of a problem. His interactions with Rey and Kylo seem to show that there are no other clone bodies he can transfer to, and his only hope is getting another Force user to let him possess them. When Rey decides not to use her hatred to kill Palpatine, his last resort was eliminated, and he was basically doomed to permanent death.