If you said people who carry firearms when drunk, I might be inclined to agree.
But if you mean more generally people who drink, vs. people who smoke weed, I would expect to find the type of people who use illegal drugs (even weed) would be far more concerning on average.
I’ve never seen someone stoned outta their mind get into a fight with strangers, friends, or beat their spouse. I have seen drunk people do that though. I’ve been attacked by drunks myself. I’ve never been attacked by someone who is high as fuck. And I spent years smoking, and hanging out with a huge amount of folks who smoked weed.
The connotation that because marijuana is an “illegal drug” in some places means those people are more inclined to violence is borderline absurd. Violence is more likely to happen to producers, and sellers, because they have no access to the police. Producers and sellers are also categorically different than someone buying it to consume it.
Can someone who consumes weed be violent? Sure, but I would highly suspect it’s correlation and not causation.