has anyone felt so disappointed for not getting laid?

So my boyfriend and i were on a yacht yesterday in bed just making out and stuff and it was so romantic but it didnt go any further because he was drunk and wasnt feeling well, now i really wanted us to sleep together because it would have been my first time and it would have been perfect, now im just in bed crying because i am so disappointed... has this happened to anyone?