Nah no way he's dead. I know he was stabbed Julius Caesar style and it's hard to come back from that but Melisandre came back in time for his death. Lord of Light practitioners can bring people back from the dead. Remember when Arya declared the Hound a murderer and Beric sentenced the Hound to trial by combat and dies? Beric was revived after the Hound killed him.