If you take the kids away, provide a quiet environment for him, make sure he's got water and an aspirin, a bucket if needed, some plain toast or crackers etc, let him detox and rest, then you are a very kind sensitive and supportive partner.
Being hungover is a self-inflicted wound. Nobody holds you down and pours the drinks down your throat, it's an illness that you bring on yourself. I provide far less sympathetic care for hangovers than I do for other illnesses, as one should completely know better, but that doesn't mean the person isn't physically suffering at this time and could use the help.
I think the question is, how often does this happen? Does he get hungover and demand 24 hours in bed once a week, couple of times a year, or has this almost never happened before? Because if it's an incredibly rare occurrence, I would say be the support of partner, give him the care he needs as he's feeling crummy, and later when he's feeling better, state plainly that you don't want this to happen again. If he doesn't drink that often, if this almost never happens, then you probably won't have to worry about it.
If this happens frequently, like after most parties or several times a year, then you've got a husband with a drinking problem.
Fun fact, it's good to know what a standard sized drink looks like (beer at 5%, wine at 12% and spirits at 40%... What the size of a standard drink is because it's the same the world over) And even though every person is slightly different, how big they are, how experienced they are, how old they are, and other physical parameters that might define how they handle alcohol, for the most part, most biological males can have two standard drinks in 1 hour and biological females can have one standard drink in 1 hour, and they can stay below the illegal blood alcohol concentration.
If exceeded, that's when you're going to go beyond what your body is able to process in an hour, and that's when you're going to get toxic levels and that's when you're going to get hangover.