Yeah, modern psychology has definitely understood that Freud was full of shit. I was taught a little bit of Freud but more for historical purposes on how the field of psychology developed. My teachers never shied away from saying just about everything he thought has been more or less "debunked." Two things that modern psychology believes he was right about was that 1) dreams are the subconscious mind's way of working through one's issues through symbolism, but it's taught that Freud's interpretations of dream symbolism were dead wrong, and 2) "talk therapy" (I.E. the trope of the patient on the couch telling the psychologist / psychiatrist their problems, like you often see on TV) is a big help in therapy.