Yeah not sure how I feel. You shouldn't be in that situation twice and hard to argue against the lifetime ban on second offense. Whether that ever actually happens to a high profile player, will never know.
But any kind of high profile job and you probably wouldn't last past the first allegations, employment wise. Remember players are employees.
Regarding weed, I'm all for making it legal and just tax the shit out of it and the same rules as alchohol/tobacco but as long as its still illegal, you have to suffer the consequences if caught.