I was single for many years between my first husband and my husband now. I grew up going to the Church at the end of the street and never learned how to dance because they taught that dancing was a sin.
When I divorced my ex I started going out with a new friends and when I learned how to dance country and western you couldn't keep me at home. I even won trophy's at local dance competitions. First, let me say I didn't really like alcohol so I was always designated driver. I was listed on several of my friends insurance as a secondary driver in the event we had an accident that was my fault. Second, for the first time in my life I felt feminine and desirable. I loved the feeling of being on the dance floor and twirling around in a fast waltz or a speedy two-step. my friends and I went out nearly every night of the week. I was getting a validation I had never found before.
I joined a different church later in life and we have monthly dances for the youth and several times a year we have activities where just the grown ups get a chance to have an evening out and dance, usually at the church but sometimes out somewhere else. They also had a singles group that went out to a local club one night a week, before all the crowds starting coming in a clouding up the air with cigarette smoke. So dancing is not an issue for religion. There are churchs who believe it's okay, within limits of how the dancing is done, ie: no dirty dancing.
So, when I married a man who had 2 left feet and can't dance, I went through a lot of the same feelings. We took lessons, ouch, we dance at least one time at each dance we attend, he tries really hard but it is painful to do and painful to watch him try.
I can't tell you how much I miss that feeling on the dance floor. I went out a few times with my sister when she was a ballroom dancing instructor and I felt so out of place. I did dance with some of her friends and had a good time but really wanted to be with my husband.
So, here's my advice. If your church is teaching your family that dancing is wrong then perhaps you need to talk to your husband about researching the churches in your area, maybe it is time you attended a different one. If he can't go out to dance and not drink then maybe he is dealing with drinking as the issue and not the dancing. Maybe he, and you, need to talk to someone about that first. If he really didn't have an interest in dancing in the first place and only did it to fit into the crowd at the club then you may have to face the fact that deep down he doesn't like dancing. There are so many things he could be thinking that only he can tell you what's going on.
Now, to the alcohol issue. I only have one evening I can't remember much of, I only had two Colorado Bulldogs, but I do remember I drove on the highway to get home. It's a miracle I didn't have an accident. To me it seems like there is much more going on in your heart than just wanting to go out with your husband. You may have chronic depression, alcohol is one of many ways some people try to self medicate. You may just need that feeling of being on the dance floor again. Again, it could be so many things going and only you can find out. I think counseling is always a good option for anyone. If you think you could benefit from visiting with someone why not try it.
Now, finally, about things to keep you busy. Volunteer somewhere, hospital, kids school (you could read to the kids in younger classes or help out in other areas like the library), a local shelter or clothing room/food bank, if any of your kids are interested in things like soccer or baseball you could be an assistant coach or coach, look to your local Vo-Tech or Junior College. I took Good Life Cooking, other cultures cooking classes, cake decorating, dance, piano lessons, tennis technique, weight lifting, exercise classes, all kinds of classes I just thougth would be interesting. I got an Associates degree and then went on to work on a Bachelors degree. I started doing scrapbooking, painting, I read lots of books, etc...to say the least I stay so very busy. I miss dancing but then I have so much more to fill that void now.