I'd also say it depends on how the setting handles gods dying.
For example, if you're playing in Midkemia, dead gods can be reborn given worship and time, and the other gods continue providing power to the clerics of fallen gods, to the point that the vast majority of the world don't even know the gods in question are dead.
If there's any midkemia fans out there, yes I know I just butchered that explanation for simplicity's sake. Please don't nitpick