Yeah, 100%. A good partner will provide as much support as they can, but in cases like this, the support is coming from a peer. It is a different situation from expecting not only psychological support but romance to fall out of the ether in the same package, or coming across someone who needs some serious help and saying "I can fix her."

At the end of the day, this kind of support must be born out of compassion for the person in need, not self-interest.

When it comes to meeting people and leaving a good impression, you want to make sure you have your expectations calibrated. We all have our demons, and opening up about them is a part of the growth of any relationship, but you don't want to just dump this on people and make them pity you like you're some poor bird with broken wings (especially if you think the fact that you haven't gotten laid in a while makes you some poor bird with broken wings). You don't particularly even want to make the discussion about yourself at all. Talk about hobbies (get some hobbies, typically there are organizations of people who do hobbies and you can go to them). Talk about shit that's going on (you may not be aware, but there's some wild shit going on). Play some games. Do some trivia or karaoke. It's not a job interview. You have better odds stumbling across the opportunity to say something interesting about things other people care about than you do dictating your autobiography and hoping other people find it interesting. Then at the very least you end up being that guy/gal/nonbinary pal with the interesting and memorable takes and/or daring, heterodox choices in karaoke performances. People remember you, and not as a buzzkill. You might even become the subject of conversation when you're not even around.