How do you cope when your partner is thriving and you aren't really surviving?

My partner and I have been together 18 months and I truly love him and only want what is best for him. He's thriving at work and has been doing a lot of personal reflection and work (therapy) to come into the man that he is today. He has found communities, both social and some fetish-based, and I can safely say he is living his best life! He gives me a lot of credit for providing a safe space for him to explore and grow.

I on the other hand am not thriving. I've been unemployed for a while, I can't seem to get back into my career... it's not a lack of talent it's a lack of opportunity. I can't seem to find friends and don't really have a community to call my own. My partner wants me to move in with him but being unemployed feels like it's so unfair to him because my contributions to our monthly expenses will be very low. He knows this and doesn't care and still wants me there with him. We've managed to cultivate a friendship with a couple that he goes out with one or both partners frequently. Because I live in a different city I don't have that opportunity.

My partner is so supportive and wants me to regain the successful career I had previously and to join him at events and be by his side but it's hard when you just feel so ill equipped and unworthy.

Thoughts?