A bit worried about my bfs behaviour

I'm 36, my bf is 32 and I'm 25 weeks pregnant. My bf used to be a big homebody. He didn't go out much. He's quite introverted. Lately he's been going out more with a group of friends though. Nothing alarming. He'll usually go out with friends on Fridays and come home around midnight, he may go to a club once a month or so, and I can usually expect him to be out of the house doing various things with friends for the largest part of one of the days of the weekend. I'm very tired due to the pregnancy and stay home most evenings and weekends so I do feel a bit abandoned at times, but it's not to the point yet where I'm too concerned.

Last night he went out and didn't get home until 8 am this morning. He was so drunk he had thrown up in his friends car and his friend had to support him up the stairs to our appartment. He got this drunk in front of some of his colleagues as it was a birthday party in a club for one of his colleagues, only one colleague witnessed him throw up apparently. He's now sleeping it off. I've only seen him really wasted once before in our 3 year relationship so this is not a habit, but I do find it worrisome. This combined with the increase in being out of the house has got me wondering what to expect when the baby comes.

He's African and comes from a much more hands off and collectivist community childrearing background, whilst I'm counting on him and I to do 99% of the child rearing as we don't live in a collectivist society and don't have a whole community around us to pick up our slack. Meaning not much going out in our futures.

I'm worried about potential reputation damage at his work too. He works in a financial institution and needs to be professional around colleagues even outside of work in my opinion. Getting this drunk at his colleagues birthday party is not great. His friend did reassure me that he wasn't the only one who got drunk and that there was only one colleague present when he threw up.

What do I do when he wakes up?

Do I let it slide as this isn't normal behaviour for him?

Do I talk to him about this not happening again?

Do I broach the subject of my concerns about his increase in going out and if this will continue when the baby is there?

Any constructive advice is welcome.

Ps. I'm not looking for comments like leave his ass etc. I'm hoping for constructive advice on how to deal with this specific situation in a mature way with a man who isn't perfect, but is generally a good man.