I don’t know what to do anymore

I have been with my fiancé for 5 years and we have a child together. He’s a troubled man with trauma from his teen years and next week we have an appointment to see if he has undiagnosed neurodiversity.

The issue I’m having is that he is a decent person when he is sober but when he drinks, I honestly can’t stand being near him. He’s so aggressive in general, he’s a massive conspiracy theorist to the point he actually sounds like he’s insane. He’s unbelievably defensive when I say or ask anything. I honestly want to just pack up my stuff and just leave and no matter how many times we speak about it, nothing changes and we go through this cycle every weekend when he drinks. As soon as he’s sober, he’s a different person.

He says he’s going to get ‘2 more beers’ and comes back with more. It often ends with me having to almost carry him into bed. I hate it. I hate everything about it.