falling asleep during sex?

Girls hello!!

Two days ago I experienced something I never did. We were drunk/high with my boyfriend. And we started to having sex,

I blew him ✅

We did it missionary✅

he went down on me✅

but then when we were switching positions we were gonna do from side you know like spoon?? Apparently I fell asleep. And when he was in me? I thought it may be common but he got a bit insecure about this or at least I got that vibe. He doubted his skills/dick if you know what I mean. I tried to tell him that maybe it is common and normal and it’s not because of “me can’t even feeling his dick”. So ladies have you experienced something like this? Please share your stories so maybe I can share some of them with my bf and he can see that it happens.

Thank you!!!