Alcohol is a mind-altering drug! And I expect it has worse long-term consequences than quite a few of the other drugs that have become more mainstream recently.
Used responsibly it's perfectly safe. Much less harmful than alcohol. I don't know why people assume that something is unsafe just because we give it to horses. Do you think people want to harm their horses?
No, weed is not a one way path to a death sentence as you become a raving Satanist! But it also isn't harmless and there are things to keep an eye on, just because it doesn't kill you doesn't mean it gets the all clear.
If you want to do it, go for it, but please be aware of the potential issues.