sex issue

so me and the guy i’ve been with for a little bit recently tried to have sex, he was a virgin and i wasn’t. the first time we tried it literally just wasn’t working out bc he couldn’t get it in and i was barely wet so after a little bit of trying we just stopped. i felt bad bc that was his first time and it just didn’t work out. we tried to do it again a few days ago and the same exact thing happened. both of these times were at parties and we were both drinking but sober enough to know what was going on. ever since then it’s just been weighing us both down but we don’t want this to cause us to split up or anything. so i need advice on how to stop feeling down abt it and advice on how to fix the sex i guess.