So I found out I'm gonna be a dad for the first time, the baby is coming in November. I really excited and really happy, but at the time I'm freaking out, all I hear and read is people telling me my life is over, no more social life, no more sports, no more hobbies, no more sex... Will I be able to hang out with friends, make beer, go on 100km bike bike rides? I'm sure It can't be that bad, I expect it to change my life completely, but I'd it to the point that I'm only living for the baby? I'm just curious as to other people experience when they had newborns/young children.
It isn't quite that bad, but it is a huge change in your life. 100km bike rides are probably going to have to be reduced, but sex, hanging out, watching sports, brewing, etc. are all still there, they will just be less frequent (at least some of them will be). Some people definitely go to the extreme and make it so they are only living for baby, and nothing else has any time or room, but it doesn't have to be that way. If you want to maintain a healthy relationship both with your spouse and your child, it SHOULDN'T be that way.
It does depend a LOT on your wife, of course. If she tries to make everything about baby, and no time for anything else, you will have a bad time unless you can convince her she doesn't have to do that to be a good mom. Talking early and often about how things will be is the best way to avoid conflicts as your lives change. Make sure to schedule time for just one another. If family is close and trusted to babysit, that is perfect. Even if no one is nearby, it is worth finding a reliable and trustworthy babysitter, because nothing will make the walls close in faster than NEVER having time for just the two of you.
Especially early on, babies are easy. Yes, they can be very demanding at times, especially with the crying, never sleeping longer than an hour or so, etc. But if you work early on getting the baby on a schedule for feeds and naps, you will have quite a bit of downtime during which you can do other things. You won't be as free as you are now, obviously, to go watch a movie on a whim, or stay out at a bar or show late without a lot of planning for who will watch the baby, but those things don't have to be eliminated entirely.
To put things in perspective, my wife gave birth to our son when I was working a 9-5 job, and our lives changed. Lots of the things we took for granted were reduced. However, I am right now finishing up medical school, which I started when our son was 1.5 years old, and even with that demanding schedule, I still have had time to spend with my wife, to pursue hobbies, etc.
Don't freak out, your life is not over, not even your social life is over, it is just changing. One last word of warning, don't be surprised if your single and childless friends seem to disappear. Suddenly, you will have a lot less in common with these friends than you used to, or at least you do in their minds if not yours as well, and that can definitely affect how willing they are to hang out. Even if that isn't a factor, simply having a lot less free time available can cause some friends to retreat a bit, so don't be shocked if you suddenly have a hard time getting some of your friends to hang out. Free beer is always a good motivator
Good luck, and again, talk to your wife, even if you don't think there is anything to talk about yet. Best to start these conversations when you aren't both running on 3 hours of sleep a night and mutually frustrated over how difficult and different it all seems at first.