AIO ADVICE PLEASE

so i met this guy that i like he is everything ive ever wanted in a man he’s so kind, sweet, attentive, caring, etc. however he’s horrible in bed like absolutely horrible like 2/10. i hate having sex with him i dont enjoy it last night i cried (privately in my bathroom) bc it was so bad none of us finish bc i always stop it bc at a point im so dry and so turned off i just want to stop completely. idk what to do is it possible to make this work a relationship with no sex on my end this is coming from someone who enjoys sex but i refuse to have sex that i dont enjoy. the first time he couldn’t stay hard the second time same issue but also he was going sooo slow in out motion and it seems whenever he goes fast it’s like he’s almost out of breath (like he can’t do it for long with out getting soft). not to mention we can only do one position which is missionary bc it’s not long enough for doggy or for riding and he won’t stay hard enough for it, and whenever we switch positions he goes soft and it’s a whole deal for him to get back hard and then i’m turned off and annoyed. my mom has grown keen to him they’ve met already we haven’t made anything official yet but i feel like the reason for me to end things would be so shallow. the dating pool clearly has piss in it and i fear that i will struggle finding another guy that’s good like him if only he was better in bed we could make it work. we’ve talked about this and i told him we can work on it together but idk how much i have left in me we are supposed to hang out and possibly have sex again this coming sunday and i dread it bc i don’t want to be disappointed again we are both 21 years old (F) btw.