I'm inclined not to believe he'll die, because of course I've never heard of a protagonist dying for good in a power fantasy, but then this seems like an opportunity for him to meet the goddess again if he "dies". Maybe he'll somehow get to talk to her again, gain a new power and then revive.