I think it's perfectly normal to be disappointed. Did your friend know how much you were looking forward to the hotel stay? If not it might be worth letting her know, she might change her mind if she knows how much it would mean to you. If you can't do it this time then perhaps arrange a night out with the focus being staying in the city, having a whole evening and hangover away from the kids, etc.