Depending on the jury, voluntary intoxication is a defense in my state. But that's all that it is and it's not guaranteed that the jury will buy. Being that he is a cop he is more then likely to show up to trial and do a perfect testimony addressing the jury. Hopefully the DA can take it easy on you and work out a deal with your lawyer. In your case it's somewhat justified.
I was charged with a misdemeanor attempted assault back in college during a football game when a cop came over arrested me and wrote in the police report that due to me being a big guy and intoxicated, he feared for his safety. They also arrested 30 other kids that day and I'm pretty sure the midget cop got sued. At the very least he didn't work for the school very long.

