I definitely hate to see somebody's 'career' ruined because of one stupid action, so I am leaning towards, 'yes', but I do believe community service of some kind should be invloved. I know the situations you gave are pretty serious, but the Kobe and Roethlisberger situations are very questionable (since there is really no proof of anything legal) and all of them are already professional athletes in the limelight.
They just don't want to promote this type of behavior in college sports, which is understandable. But, if he had NFL talent before this, then I don't find this serious enough to take that away from him.