Nietzsche is just not naive and because he is not naive he is quite pessimistic. Exactly what the death of God actually announces would be the demise from the human as we realize it. One has to think about this crack from the history of your human in Kantian terms. https://youtu.be/ZacJTN9xkEs