Is there any other deaths other than 'Just' and 'Heroic'? Not like the 'die-and-come-back, but is there a third permanent death for godtier?

No, Just and Heroic are the only ones.