Palpatine’s death at Vader’s hands was probably the most incredibly poignant, perfect ending possible to the saga. Despite ROTJ’s many flaws, they really nailed that ending. It’s so rare that a saga like this wraps up with such a perfect resolution.
Of course, Lucas decided to decrease the poignancy factor by ~30% by dubbing in Vader saying “No! No!!!” before killing Palpatine. Sometimes I just don’t understand that man.
And I think Palpatine’s death was probably the least ambiguous death possible. Nobody ever had any doubt that he was dead. Future installments that unwisely decided to resurrect him (Dark Empire, Rise of Skywalker) did so through cloning - which doesn’t negate the fact that he did in fact die in ROTJ. Just because someone dies doesn’t mean a clone of that person cannot later be created.