Sounds like what you need more than a relationship right now, is a lean towards a positive attitude .

Our reality tends to follow our thoughts. Perhaps it's time to work on loving yourself, and finding things - besides humans, that make you happy, that feed a passion ?
The rest will follow ...

You are young & have time to learn what you were not taught by your upbringing. Your hormones are calling you to breed but your psyche is retescent. Slow down. There is no hurry at 24. Relax & enjoy your youth lest it be wasted on the young.

well the achieving of goals should not be the driving force, that will surely lead to disappointment, trying to enjoy the whole journey is surely more satisfying, if all you are focused on is the inevitable failure of any endeavour lifes gonna be pretty much as you make it

Yeah..starting a new relationship can be rough. Many/most people are driven by physical urges and don't even think about it..they just put themselves out there and take the risks.

Demisexuals like me lack that sexual attraction urge, so we often don't bother.

Sorry you're having a bad time. I hope things get better for you but yes, it's discouraging. Good luck!