Freud thought that God and religion were ‘illusions’, and didn’t like Jung’s interest in religion, mysticism, and the paranormal.
Jung thought Freud was neurotic.
Near the end of his career, Freud expressed regret at not having delved more into the occult.
As for his thinking that belief in God is wish fulfilment, Freud apparently didn’t catch the fact that his own rejection of God was precisely a form of wish fulfilment.