You are being weak because you are weak, he's left you in a weak position. You want someone to come and make it alright, look after you, protect you. That's the job of our partners most of the time so you're looking to him, even though he is the one who is causing you pain and hurting you. He cannot be that person. But it feels like he's all you have. You don't, you have others, and you will have others.
Listen to what he's saying. Firstly he's saying he met this woman a couple of months ago and there has been no sexual contact. That's bollocks. It's at least eight months ago I'd say from what you've described and men DO NOT LEAVE for women they've had no sexual contact with. He is lying to you.
He is also saying that he sees no future for you. I'm sorry, OP, I really am, but listen to that. He sees no future for you. That is not going to get better. Of course you want affection from him, you've made him into your everything, parent, friend, boss, colleague. But this was unhealthy and you know it.
He does not see a future with you. He has said he does not love you. He has saii he does not find you attractive. He has cheated on you and lied to you about it. You have to have this sink in over the next little while. You do not want this guy back because he does not feel about you how someone should feel about you. And because he will definitely cheat on you again.
You love him because you don't know what else to do. It's such a shock. He does know what he wants. He's told you. He does not see a future with you. He does not love you. He has met someone else. He is the villain here, he is the one who has failed, failed at a relationship, failed at fidelity, failed at telling you the truth. When he hears that you still love him and want to try again he hears, 'hmm, I have two options, two women who love me and want to be with me. Phew. I can spend my time trying to work out what I want.'
FUCK what he wants. Are you listening? FUCK what he wants. He has done what he wants at every single stage of this, from meeting her to not telling you about it, to lying, to taking your money, to overpowering your life so you've lost your friends and a sense of independence so he is the centre of everything, to two-timing you, to lying to you about it, to leaving without explaining and then going straight to the house of the woman he's been cheating with. He has done EVERYTHING he wants. And now, having destroyed and hurt and lied he is going to take more time to work out what he wants between these two damaged, vulnerable women.
FUCK what he wants. you don't even know what you want yet. You're not even close. You can't even be close to feeling the truth. All you are doing now is searching for someone to love you and tell you everything will be okay. He is the one not making it okay. he is the one not loving you. He is the cause of your distress, not the cure. Don't see him. Or if you do, please bear this in mind. He cannot save you or protect you from himself.