I think you and I have a lot of similarities and maybe I have something to offer here. This is just the experience from my life and I felt moved to share it.
I'm 41 and have learned that before you become a Christian, you form bonds and ties with people that are founded on non-Christian things. Before I got serious about Christ, all my relationships had things like entertainment, drinking, and whatever else in common. You don't really notice this while you're not following Christ, you just know you have friends and acquaintences and everything is what it is.
But as a Christian, priorities shift. You can only be around people for so long before an essential issue causes you to not be able to be around them. You're not engaging each other in superficialities, or playing up this or that movie or this or that thing that's going to happen. Or if you were me, you bonded over drugs or alcohol and conversation followed. You hung out with people you could do that sort of thing with.
You emphasize different things, and the behavior of other people matters. And always in the back of your mind, "Is this person going to heaven when they die?"
I mean if you're trying to follow Christ, and you're applying what's taught in scripture to your life, this is how it will be.
And the emphasis of life isn't being around other people. It's about serving Jesus, and people come and go. But the constant is Christ.
For me, I reached the crisis it seems you are going through a few years back. No friends. Just the wife and the kid, and my parents only because I have to care for my daughter at their house. And it seemed really lonely.
But I realized it's not about having friends. Sure, friends and being social is nice, but what fuels me is pursuing Christ. What keeps me going is knowing that I tried to do my part for Christ. Some days I pass out tracts, some days I just find people to pray for on Facebook or elsewhere. Some days I just try to find out how God is working in other parts of the world.
As a Christian, you have to be proactive, and seek things to do for the kingdom, and people will happen to come into your life. Maybe some lasting friendships, but this won't be your bread and butter.
What will get you out of bed and to sleep at night is not the people in your life, it's "Seek ye first the kingdom of God, and all these things will be added to you." Perhaps that can mean serving the people in your life (especially your wife). But I hope you get the idea.
From someone who was saved from suicidal depression and drug addiction, having gone through something it sounds like you are going through, that's what I have to offer. Maybe it will help
.