It is probably just something he said to counter the 'listening to you having sex' thing, but if you really think this is what will happen, I'd be just as bothered about this sort of behaviour on any night, not just my wedding night tbh.
If this is how he normally behaves, it will be an ongoing issue for you throughout your marriage, not just on your wedding day, so you need to talk to him seriously about his attitude to drinking/socialising/couple time etc. and spell out your expectations of your life together as a couple.
If this is just an occasional thing, maybe he sees the wedding as a big family party more than a romantic celebration for the two of you. Again, you probably need a conversation about this so that you are not disappointed and he can manage your expectations by either compromising on the time you both retire to bed (him a bit earlier and you a bit later) or by you accepting that the sex isn't really going to happen that night, but planning some more romantic coupley nights out on your honeymoon. If he's the type to hang out in the bar of the hotel whether you're there or not, then the problem is going to continue long after the wedding day.
FWIW, I'm not a big drinker and neither myself nor XH were at the time, but we got smashed on our wedding day and didn't DTD until a few days into the honeymoon, but we still went up together (taking a bottle of champagne up with us, before promptly crashing out fully clothed!).
These days, when most couples have sex before marriage it's not really the big deal it used to be, so enjoy the party without putting pressure on either of you for it to be the fairytale romantic moment of all the movies.
It's really about the first bit, the vows etc, not the party and 'consummating the marriage', so unless you're on the same page about that, the whole thing is pointless anyway. If his priority is spending time with friends and family while you're tucked up in bed out of the way it says something about his attitude to the relationship. If your'e confident that this is not the case, cut him a bit of slack and let him celebrate the way he's planning to.