It's complicated, and it is certainly regionally dependent.
When I was growing up in the 80's, there was a brief bit of time when D&D was the IT thing and EVERYONE played it. It was cool. Then it became passe, a pastime for nerds only. You'd get made fun of if you were known to play it. This was especially bad in fashion conscious southern California where I grew up.
My cousins in Wisconsin had it a lot easier. The only issue they had was with parents falling for the Satanic Panic. I chalk acceptance up to the fact that the area is more rural and to it having cultural cachet for being the birthplace of the hobby.
I suppose it's like any subculture, it has its stereotypes. They are rooted in truth (after all, what rock star didn't do drugs and have sex with lots of groupies).