I don't think it's ridiculous at all to not allow alcohol in your home. It's your home, your rules. My wife's dad's side of the family all like their wine and drink it whenever we get together. The get-togethers are never in our home though, because they all know they can't drink here, so they don't bother asking us to host.
If the family is offended by your decision not to allow alcohol in your home, that's really their problem, not yours. Alcohol drives the Spirit away, and is a few hours with your family really worth not having the Spirit? What else could happen when the Spirit isn't there?
You and your husband need to agree one way or another. My personal belief is that I will not sacrifice my standards ever, no matter the occasion. Family is not exempt.