Have only skimmed this but...
as a fellow non-dog lover I have to say DON'T GET A DOG.
It will make you miserable and uncomfortable in your own home. I'm assuming you are grown up enough to know that you don't like dogs and you are not likely to change your mind (even if there is a small chance that living with a dog may like them more, may make her more scared of course). You're just going to resent it more and more.
And then feel guilty because it is a living thing so you're the end of the line and if nobody else feels like/is able to take care of it, you will because you can't be cruel to animals. And then you will feel angry that you feel guilty and resent it and those who wanted it but have left you to clear up the mess (literally, frrequently).
It's not like getting a guide dog.
Any chance your husband could befriend someone who has a dog that is at work all day (the person not the dog at work ) and so maybe do a little dog sitting or walking to see what it involves and see if he really does get some of the benefits he thinks having a dog will give him? And be nice fo rthe dog not to be home alone all day too.
You have more than enough going on in your life at the moment, introducing a dog is just selfish of your husband and completely unfair to you (and the dog).