There is a theory that Nietzsche knew - consciously or not - that overman was a unreal concept. In a sense he knew that his solution to the question of meaning of life was wrong. This gradually drove him anxious up to his nervous collapse. Also overman is a concept from early and middle stage of his writing. Late Nietzsche is far more pessimistic - take for instance "European nihilism" from Will to Power.