The adjective you are looking for is "sober". If you want to say that someone has become less drunk, you can say that the person has "sobered up".
- He was drunk but now he is sober.
- He was drunk but now he has sobered up.
All of your sentences suggest that the person was more than simply drunk. The person was so drunk that he had