I don't think he should be kicked off of the team, but Charlie sells himself as some kind of Savior so he might just get rid of him.
Most people that have drank alcohol have also driven when they probably shouldn't have. Charlie can use Perkins as an example to his team and others. Suspend him a game or 2, let him give speeches to the teams and other youth around town about the dangers of driving drunk. A lot more can be accomplished by community service in this case than just kicking him off the team and being done with him.