He wants to explain the complete collapse of western traditional metaphysics with the death of God.
Nietzsche said that God died because the current Christian system could not satisfy his belief in God. Since his own aesthetics told him that he could not be wronged, he chose another way to express his belief, that is, to be an apostate.
Facing nihilism brings narrow materialism. Nietzsche faced the corruption of faith and superstitious people. Not our current philistinism and rough black. He really wants to rebuild his faith. As you said, he is trying and calling, but he is a poet, not a scientist. So I can sing with you, but I won't show you the way.
God is eternal, of course not dead. If you go to see a movie called "God is not dead", you will find the answer.