I can sympathise, just remember a) there are always events planned that don't centre around "going out" or drinking, and b) there will usually be smaller scale events/societies organised, sometimes for accessibility reasons and sometimes just because it's a niche activity and not so many people will join!
I also wouldn't worry too much about trying to make friends in freshers week - you have a whole year (and then a whole degree after!) to make connections with people, including those you live with, those on your course, people you meet in societies and clubs, as well as random people you might happen across and have common interests with.