I imagine a lot more people know than his sister. When I was drinking I thought I was successfully hiding it. Everyone around me knew, but didn't say it.
There's no shame in going to your family for support. You need as much support as possible. Is your husband willing to get help before the baby comes?