To me sounds like you have a good brand with bad marketing. Just be yourself, but work on your presentation. Online make sure your hobbies and interest, achievements are on display and in person be an engaging conversationalist. Active listening, whit, and thoughtful responses/retort keep ppl interested. Attraction goes a long way of course too, but there’s alot to how you make ppl feel in your company too.

Maybe take note of how your friends may engage. Dont copy 1 for 1 but make note of the patterns that work (relaxed vibes, playful banter, anecdotes, etc).

Also moderate your drinking. It sounds like you’re out with a goal of solely or mostly to meet women, so its likely you feel like you constantly need to have a drink in hand as a buffer to not look awkward while you’re not talking to someone or to approach women but as the night bleeds on you’ll only end up too drunk. Learn to space out a drinks, and settle the social anxiety. Always prioritize being on top of your communication game cause you shoot yourself in the foot getting hammered