Help!! New guy can’t wear condoms

Girls... I can’t go on the pill because I get mood side effects but my new guy can’t keep it hard wearing a condom! I’m so attracted to him. He’s literally perfect and so hot and kind. We waited months to have sex and I’m sooo disappointed! I just want to feel him hard inside me. He insists on wearing a condom because he’s really afraid of me getting pregnant but he can’t keep it hard 😭 Help!