You can’t give your DH a curfew, he’s an adult. you can state what you’d like (and any implications that might arise as a consequence), but you can’t decide what he can and can’t do. If he wants to go out, as long as he is able to manage his responsibilities the next morning, he is free to spend some leisure time as he wishes. And you should be given the same freedoms- if tries to place restrictions on your free time/stops you having any, then he is wrong too. And a hypocrite.
Having children does not mean you suddenly have to give up all social interactions/nights out/hobbies etc- I haven’t, nor has my DH. I go out with friends (including some late nights and night(s) away) and take part in my hobbies and have done since they were small. As did/does my DH, and I think it is really important that we both do so. It’s fine if you prefer to stay at home, of course, but that shouldn’t mandate your partner/spouse do the same. As long as you have equal opportunities to spend time as you please, and neither are spending money your household can’t afford on going out/hobbies etc, and your activities are not rendering you unable to carry out family responsibilities outwith your free time, then all is fine.
If any one of those criteria are not being met, you have a problem that needs addressed- e.g. doing the hobby/going out less frequently/spending less if it the cost that is the issue; ensuring the other partner does get their fair share of free time; getting back earlier/going out or doing your hobby every other week.
However, you say he is a good father, spends time with the children, works hard and pulls his weight with chores/household tasks. If this is true, then he must be picking up his share, even if he is out late.
if he is coming home pissed and waking you/the children up- he needs to address that. Yes, being absolutely rat-arsed every Friday night is probably not ideal, and I’d be asking him to cut back on that because it’s not great- but as long as he is able to get up when he needs to (I.e. not lying in bed with a hangover the next day) and safe to do what he needs to do (look after the kids, drive etc), then I think it’s harder to demand he does what you want, as you want all the time.