Bsn, my position was and is that normative hashkofa is that Moshiach will not be from the meisim, and i thank you for showing me the sdei chemed which supported rashi’s non-literal reading of the gemara in his lishna achra.
The ramban paskens not like the gemara, or he holds like the sdei chemed/rashi’s lishna achra.
I was not aware of ths abarbanels shitah that Moshiach might be from those who come back from techias hameisim – it’s an interesting footnote, but the consensus of hundreds of seforim, including chasidishe seforim – and chabad seforim! – is not even like that abarbanel, let alone the words you put in his mouth about a second coming, which is totally unmentioned anywhere.