I went to uni in amsterdam, so maybe/probably uk uni culture might be very different so take my advice with a grain of salt, BUT I drinked and partied most 3x a year during uni and had lots of friends that lived far away / had to catch trains that stopped working overnight.
I would say university is what you make it, and you can choose the right friends that are compatible with your lifestyle. There were absolutely groups of people whose favorite activity was drinking. My friend group liked to meet to “study”, have coffee, play volleyball, bike, drink a beer at the local park on the off weekend, go to concerts/comedy shows/open mics, and try cheap restaurants.
What really helped me to become close with these people was the university library, as most of us would hang around and study there or have lunch after lectures. I also met a lot of people through clubs so the magazine club, the finance club, energy club, etc…
You absolutely don’t need to get smashed every weekend to make friends and frankly you’ll thank yourself later down the road for it!