If he shows up under the influence of drugs/alcohol, you do not have to let him pick up your child. And you wouldn't be in contempt for refusing to let him take her. Your child's safety comes first.

And if he does show up under the influence, call the cops. He probably shouldn't be driving, either. And you will documentation of your reason for refusing his parenting time.