I disagree that his ideas are indespensable to human kind because if not for Freud, someone else would have popped onto the scene with the same ideas. With that said, people with genuine ideas are only brought to the public eye when what they're saying is deemed beneficial to the current direction of society - that was even more true in his time.

In all reality, he was probably a genius. Unfortunately, he was working only with the tools available to him at the time. I believe he was genuinely trying to solve problems, but he used the wrong approach due to his limited area of expertise and experience.

As you said, the best we can do is learn from his mistakes and hang on to his more unique ideas. This is the beauty of being alive TODAY - everything that's ever happened historically is behind us, readily available for our analyzation, learning and growth.