Atheists will believe anything. But then, so will Christians. This is due to human nature—we prefer to believe what we prefer to be true, as Sir Francis Bacon said.
Accordingly, Freud never got it. He never realized wish fulfillment works both ways.
Aldous Huxley put it this way:
“Science does not have the right to give to me my reason for being. But I am going to take sciences view because I want this world not to have meaning. A meaningless world frees me to pursue my own erotic and political desires.
He was working off of a supposition, just like creationists are. They have decided what they want to be true first, and ignore evidence otherwise.