MY Boyfriend is out every weekend!

Should i break up with him or be supportive through this phase?

He is 29(M) and im 30 (F). My boyfriend been going out every weekend.. friday and Saturday.both. he says he only going out every weekend to get content for his videos , which i do wana supoort his dreams.. my problem is he is on shrooms and drunk every friday and Saturday. And everytime he is on those substances he act like a totally different person. He call me a be talking non sense or if he gets mad at me he will start yelling at me.. honestly its just draining and im tired of it.. also he struggling financially but still seem to have money for a bottle and shrooms 🤔. keep in mind this is all new we been together 4 years and before he would go out like once a month and when he did go out he wasn’t acting a fool towards me. He use to be extra nice to me when he was drunk: he also mention to me he is depressed so idk if this is a reaction to his depression or what.. i dont know if i should be a supportive gf and help him through this phase or move

I have mention to him how i felt but that convo went no where

Please give me some helpful advice on how to handle this situation.