No, not at all. Did you read the Scorpio Moon Sign article I wrote? Scorpio people are amazingly strong and driven. They are smart, and have sympathy to those they are loyal to. You couldn't have a better or more devoted friend.
People go nuts because Scorpio rules death and sex, and this misconception about the sign continues. Yes, in a love relationship they can be jealous, and if you hurt them, be sure they will hurt you back.
But I have a Scorpio son too. He has the Sun, Moon and Mercury there. He got straight A's all through school, and graduated college summa cum laude.. He's very dedicated and when interested in something, studies it to death. One was the guitar, he taught himself to play it and has had three bands (he's always the leader, as Scorpios are meant to be). He also is a student of martial arts for 20 years, an elementary school teacher, and all around good guy. When my husband, his Dad, died when he was in his mid twenties, he was and continues to be the model of a devoted son. Believe me, your son will be fine.
Try to channel his energies when you see he loves something. He is creative. He is expressive. He's capable of anything he wants to do because he has strong willpower. I never read anywhere about a tendency for Scorpio Moon people to have horrible childhoods, that's an outright untruth. And I never heard anything about them having issues with their mothers either. Sometimes people with Capricorn Moons have issues with Mothers, usually overbearing ones, but this doesn't mean they love them any less. Please don't believe such nonsense.