I know he is an adult and has to deal with things in his own way, but he doesn’t think that there is a problem.
I have spoken to him about AA or some kind of counselling but he is definitely not interested.
In light of all the problems that we have had in the last couple of years, I just don’t know what to do, I thought we were doing so well and now this happens.
He might not remember alot of that night because he was blacked out. He is doing what most alcoholics do when they are caught redhanded, they try to blame others and deny they have a problem. Your H is in serious denial about his problem and doesn't really believe yet that he is this bad. But, he is. You did the right thing in making sure he understood that you would not cover up for him.
Just consider what kind of crazy mentality almost kills a little girl and jeopardizes his freedom and his career and then claims he "doesn't have a problem?" That is REAL insanity, my friend! And yes, you can tell him I said that!
The best medicine for your husband is to face each and every consequence of his drinking. I would point out to him that he could very well be in prison right now had he hit that little girl. Not only did he come very close to killing a little girl, but he was a hair away from ending his life as he knows it. I wouldn't let that important truth escape him.
In the meantime, the best thing you can do for him is to make sure he faces the consequences of his drinking every time and understands that you won't cover up for him. If you think this is mean, just remind yourself that next time he might be successful in killing a little girl. Protecting him is to hand a gun to a suicidal person, in other words.
Secondly, I would start going to Alanon so they can teach you how to live in such a situation. Banyak and Bramblerose are also in Alanon and could be a great help in this regard.