Exactly as it is said; a person that is shy towards sexually explicit topics and/or actions. This could mean that the person is INITIALLY shy about sex, ALWAYS shy about sex, or shy about one sexual topic in particular.
Being sex-shy is genderless and does not adhere to a specific sexual orientation or identification.
"I think that girl you're into is sex-shy; better take it slow, man."