Tried to have gay sex, did not work

I tried to sleep with a guy (first time), I was on top, but I could not get it right. I could not get it in properly, we tried with him bent over, or him on top of me, got it in a few times but it slipped out, it was super tight, is this normal for a first time? I'm not even big. Pretty disappointed I could not do it, we just used hands in the end to finish.