The Rambam clearly didn’t learn that gemara as halacha lemaaseh. The Abarbanel isn’t a poseik. So unless you have someone on the stature of the Rambam saying moshiach can come from the dead, any gemara hava aminas are irrelevant.
Nobody was more emphatic about that than the Chabad of my youth. Moshiach has to be alive.