I can attract women initially, but it never lasts

You see the tittle, 24 year old male I’ve been told I’m handsome, pretty(yeah im a pretty boy), etc by a good amount of women. I’m always getting glances and notice women coming within my vicinity.

Now my problem is I have no issue attracting women initially, but it’s like when I start talking it starts off good and quickly dies off, or over time they just lose interest.

While I do have occasional success I feel like I’ve been dealing with this my entire life and I can’t seem to figure out what I’m doing wrong…

I try just “being myself” doesn’t work, I try to force myself to feel a little confident same thing. And it’s a messed up cycle where every time I fumble i feel even less confident about myself.

Any advice ? I’m really struggling here, hygiene is great, I can be a bit awkward/quirky but I’d say most people that actually knows me finds me funny and charming but this is only people I’m comfortable around ..