It will take time for him.
As regards you hurting though, one thing you need to make sure of is that you're sober for you, nobody else. If you're sober for yourself, be happy and content that you had no vodka in that coke. Whilst the thoughts and feelings of your husbands are important, they must be secondary to your own. If you continue to do it for yourself in time others will begin to appreciate it, but it takes time and eventually he will begin to trust you.
Paul