Welcome to the board Lmantis, sorry you had to find yourself here but WE ARE HERE WITH YOU so take a deep breath and read.
Once you have read around this site and especially the stickies on the top of the forum you will have a more clear idea of what you are dealing with. I am so sorry you are having to go thru this while pregnant. This should be a stress free and happy time for you! A few of the ladies have already suggested Alanon, that's a great idea if you are able to get there. You will find so much support from people like you, like us, that are going thru the same thing.
Bottom line, you cannot help your husband unless he is willing to help himself and even then it's a one person job. Finding him passed out is completely unacceptable and will only get worse in time. I want to you ask yourself: is this the kind of behavior you want around your young children? Is this the example you want set for them as what a father should look like? What kind of advise would you be giving to your sister or best friend if they would come to you with this problem?
Please be kind to yourself... Pregnancy and stress are not a good combination. We are here for you so please keep posting.
Big Hug to you!
Ro