It only happens once. I think that is the only horniness point that can be missed.
*insert whyyyyyyyyyyyy gif here*
the dissapearing head one
One of the easiest scenes to miss. Easiest is probably Emily getting her skirt stuck twice. Depending on how you advanced other quests, it very easy to advance past the second one to chapter two without doing both scenes.