I remember a guy in the dorm room next to mine freshman year who would get stoned all the time. He had the stoner eyes and the slow gravelly voice and generally seemed totally out of it. Two years later we had a class together and he was like a different person! Come to think of it I saw the same with another dorm-mate.
You made mistakes, but you made them at the right time! Maybe you’ll retake some classes, maybe next summer you take a course to make up what you missed.
You have lots of opportunities to get on track.
And you don’t have to do it alone. A nice thing about college is you know other people are going through the sa mme things as you. You certainly aren’t the only person on campus with a drinking problem!