I mean, I see why that would be possible, but considering cause and effect, one is more likely to burn out their support network by having a drug addiction and mental issues than the other way around.
My support network flew away when I lost jobs, quit jobs, and finally became homeless. They get frustrated by various things and call it being negative or difficult or similar. There’s a strong unwillingness to empathize. I realized some things I did/didn’t do to attract parasitic people to my life, but I’ll digress there. Ymmv of course, but in general people are made very uncomfortable by the situation and may jump ship on a totally sober person.
Support networks only have so much energy in them, some have more some have less. They burn out as you use them, I think that’s just human nature. Richer people generally have deeper ones, poorer people generally have shallower ones, I guess because they have their own problems to deal with.
You sound a lot like my brother. And you seem to have landed in much the same position. I could not help him keep a job so I won't pretend I could help you, either. The best thing that has happened to him is he found an employed woman whose head is fucked up in about the same way his is, and so they get along nice. And she owns her place. So at least he isn't homeless at this point.