it's still nice to have some intimate moments and sex from time to time.

It's much nicer to love life so much that you can enjoy life without feeling so uneasy when that intimacy isn't around for a while that you do everything in your power to prove your worth to yourself again.

There's no sex that feels less rewarding than sex you get by doing everything it takes just to get your dick wet. Doesn't even matter if it's amazing sex with a great-looking person who likes you. Just the fact that you chase it so desperately makes you restless.

There are other ways to fill your social need, if it's really that strong. Just to offer another input, since you bring up the concept of social need: I've always been an introverted type, but I used to think my social need for intimacy was strong too, until I realised the source of that need was that I couldn't enjoy life on my own because I didn't value myself enough to feel genuinely "good enough" creating or consuming art or food on my own, engaging in a sport on my own, exploring a place on my own. It always had to be tied to "a large-scale project" that showed my skill and value to the world - or a relationship/someone else to share it with, to prove the desirability of having me as company.

When you overcome that need to demonstrate your success to yourself and learn to appreciate life for its own sake, and find fulfillment in living by your values for your own sake, you can enjoy life with significantly fewer deeply rooted insecurities. That benefits your confidence and independence in relationships, as well as your baseline appreciation for your experience of life at all the ordinary as well as the special stages. Which is not just great for you, but also the people who end up in those intimate relationships with you; although those might only be meant to be temporary.