I'm actually curious to see if Jon is gonna be LSH type or Beric type. The major difference is that Thoros resurrected Beric, but Beric exchanged his life for LSH. So LSH is still dead. A few people died before Jon was brought back, and we might tune in Sunday to see someone exchanged their life, but with Mel being involved, I don't see him being a zombie type.
Also, he was gasping for air when he came to, which makes it seem like he's living. The preview for next episode also seems to suggest that he's awe inspiring and god like, IE Azor Ahai reborn. Were he simply a living corpse, I think the Night's Watch and wildlings would be more horrified than anything else, considering all the shit with the white walkers etc. that they face all the time.
A week long wait is gonna be fucking brutal.