No...he doesn't deserve to see the kids. His actions show that he doesn't really want to see them anyway. If he did he wouldn't have acted the way he did over the weekend. If he was doing something about his addiction it might be different, but he isn't.
I am not an attorney. It seems like an issue that you really need to discuss with your legal counsel. I do know that in NY State it is considered a form of neglect to put your children in the care of someone who you know is using. Would that apply to a court ordered visitation? Do you have the same laws in your state? I have no idea, but an attorney would.