Embarrassment

"Much to the embarrassment of most of his followers, Freud was a Lamarckian...."...Freud remained from the beginning to the end of his life what one must call an obstinate adherent of this discredited Lamarckism", wrote Jones (1957)."

Source "A Critical Dictionary of Psychoanalysis" by Charles Rycroft.

This ridiculous belief was important to some of his (ridiculous) theories.

Much to the embarrassment of humanity, it can be demonstrated that Freud was full of shit.
Citizen Sofa.

Freud did not believe in non-sexual love.

Freud, admittedly in the name of science, did not believe in non-sexual love.

"Freud constructed a "model of human nature." This model was constructed in the spirit nineteenth-century materialistic thought. Man is conceived as a machine, driven by a relatively constant amount of sexual energy called "libido."

Eric Fromm, writing in his book "Beyond the Chains of Illusion: My Encounter with Marx and Freud." 

Eric Fromm, to his credit, was not an unquestioning disciple of Freud, if he was a disciple at all.
Eric Fromm was a psychologist who worked from some of the perspectives of Freud, but who was definitely distinct from him.

Eric Fromm did believe in non-sexual love. But he was not religious and he saw himself as working in a scientific tradition - as did Freud.

I think it is obvious that on this question Freud was also wrong and discovered nothing whatsoever.