the sex isnt good

so I've been with my boyfriend for about 10 months and I really like him, we get in well, hes good looking and funny and I enjoy spending time with him... but the sexual chemistry isn't there! at one point we didn't have sex for two months... I enjoy cuddling too but cmon!

also when we do try and have sex he can't stay hard for me... I've never experienced this with any of my exes is it me am I the problem? its so frustrating wanting to have sex with him and him going soft on me... literally! I mean we do other things instead when it happens but its not the same... he also doesnt really seem to want to talk or open up to me about it maybe it makes him feel not very manly?

can I carry on like this always hoping it'll get better?

can I do this long term...? but I like him! advice?