Omg that’s absolutely vile, you have every right to be livid too. Now he’s a father he needs to sort his priorities out, I’m guessing he wasn’t fresh as a daisy next day either to help out, absolutely gross behaviour. I would put him on his last warning and say if you find out he’s ever done that again we’re done. What if he was to get a dodgy batch what would you tell the kids! I’d be livid too for many reason x
I’d tell him to sort his shit out, tell him like it is. If he knows you don’t want it in the house are you happy for him to do it elsewhere? Or do you need to have a conversation with him about doing it full stop.