Actually, the bottom line is that smoking/possessing weed is illegal. It doesn't matter what the research says, it only matters what the law says.
You can call people hypocritical all you want (yes, I fall into that category because I experimented plenty as a younger person), but the problem is, most people aren't high profile athletes getting a free $150,000 college education whose name is going to make the news if they get caught doing something illegal. There are probably hundreds of regular students busted on a monthly basis for drinking, smoking, etc, but since they don't play football or basketball, we never hear about it. But when an athlete does it, it not only embarrasses himself and family, but also his coach, team and school.
So, whether pot, or crack or heroin or anything is helpful, harmful or totally benign, it doesn't matter if it's illegal.