Anything illegal in 40 states likely has an actual stigma.
Obviously its not stigmatized enough to dissuade Elon from publicizing his use of weed. I'd say partaking in marijuana is more acceptable in those 40 states than being non-straight based my own experience.