Nietzsche is not naive and because he isn't naive he is quite pessimistic. Exactly what the Dying of God actually announces may be the demise from the human as we realize it. Just one has to consider this crack from the background from the human in Kantian phrases. Kant famously https://youtu.be/ZacJTN9xkEs