My two cents. I got married at the age of 31. I wanted a big wedding because I have lived in lots of places and accumulated lots of good friends and I have a big extended family on both sides. I too had dreams of a gorgeous location, but knowing my mom would want to pay for much of the wedding (I'm the only daughter), I didn't want to rack up a huge bill.
I picked the church I was baptized in and the one my family has always gone to. For the reception, I picked another Church's banquet hall, which only charged $35 per person for appetizers and dinner. We paid out of pocket for the liquor and got to keep whatever was opened but not consumed. The hall was very nice (don't think bingo hall) and the food was outstanding. Nothing extremely fancy, but no one complained. Because of the per person cost, I invited everyone I wanted, and had about 200 people in attendance. I invited people I worked with as well, even though my wedding was four hours away from where I lived at the time.
I tried to cut costs on certain things and picked a few things that were musts for me. I wanted a cake that looked like a stack of presents with a big bow (I got married around Christmas), I wanted red roses as my bouquet, and I wanted Christmas balls with my husband's and my name on them with our wedding date. The cake was pretty expensive but was perfect. I got my dress at David's Bridal during a sale and only spent about $200 on it and I can't imagine wearing anything other than that dress - it was gorgeous and fit perfectly.
Nine months after my wedding, my parents lost both cars and everything in their basement (washer, dryer, heating system, clothes, furniture, etc.) after a flood stemming from Hurricane Floyd. If I had sunk them into debt because of my wedding, I would have felt awful. One year later, I had a flare-up of my thyroid cancer and luckily insurance covered everything, but it could have been a financial disaster.
Also, I changed jobs shortly after my wedding and never saw the people who came to my wedding from my old job again. I had spent so much time going around to all the people there that I didn't spend quality time with anyone and some people I only said hi too - even those who had travelled far and I only see periodically because they live far away. That bothered me.
If I could do it all over again, I would've had a smaller wedding with the people that really mattered to me and my husband. Maybe around 75 people. Then I could have picked a nicer, more intimate place and spent my special day with very special people.
I learned that my wedding wasn't any more special because so many people were there - it was actually probably less special because of it.
But maybe you can take this from my story - decide what is more important - lots of people - then cut costs to make that work - or having less people and be able to have something more high end without breaking the bank.
You are only thinking about your wedding, so spending $40,000 on your big day might not seem like a big deal. But ask yourself what will happen if you or your husband to be loses a job. Or gets in an accident. Or wants to buy a house. Life is full of unknowns, so I would avoid sinking yourself into debt for just one day, even if it is your wedding day. It can be very special without being very expensive.