"you’re wound awfully tight = stressed. Not relaxed.

Sex releases chemicals in to the brain that make a person relax, well orgasms do, I'm not 100% sure if sex without orgasms does. So, if someone had sex and he was still stressed and nervous it would seem strange. And yes, "wound" is the past tense of wind. The saying - or idiom? Comes from when we used to have toys that had a spring inside, and you had to, "wind it up" to make it work, people would say you, "were really wound up" if you were stressed and nervous or really angry about something, or as we say here, "I'm going to wind him up, watch this!!! John! The boss says he wants you to work until 12 every night for a month!!!!" - John says, "WHAT!!! I start at 06:00 all ready!!! I HATE THIS COMPANY! THIS STUPID JOB!!!" - and we all laugh because it's not true, we just wound him up hahahaha Ahhh what a whimsical way to start the day, a Chinese girl asking me what awfully tight meant...... :D

Wound is the past tense of wind (as in to wind the clock). And "to be wound up tight" generally means the person is very tense or stressing/stressed out.

hi there ! you are all wrong ! in that scene that word meaning is nearly : informed conscious deliberate lucid consciously mindful well-informed calculated realized conscientious