One who views the sexual expression of oneself as frightening or offensive, such people have generally be trained since childhood to consider sex unnatural and different from other human behaviors i.e. eating they will typically fight tooth and nail to maintain these conventions even in the face of logic.
Yep, a hornophobe. You've met one, you're probably thinking of him.her right now.
The opposite of Jim's dad from American Pie, perhaps.