Does a divorce issued by a husband while he is intoxicated count, especially if it was his third divorce?

Pronouncing divorce while angry or intoxicated does not prevent its effectiveness, unless the person was completely out of touch with reality and reason.

So, if you pronounced divorce while unaware of what you were saying, your divorce is not effective. However, if you were aware, then your divorce is effective. If this was the third divorce, your wife has become irrevocably separated from you (baynunah kubra), and she is not lawful for you until she marries another man, he consummates the marriage with her, and then divorces her or dies, and her waiting period expires.

You must also offer sincere repentance for consuming intoxicants, as it is one of the major sins.