Isn't there a prophecy that John is going to die a permanent god tier death? Does that still apply or did it get retconned? Thanks!

No, there isn’t a prophecy about his death, Doc Scratch mentioned that he’s he’s convinced John’s death won’t be “as a scoundrel”.