It plays at 100 decibels from a source within three feet of the contact--too loud to be able to maintain a conversation. It plays continuously for as long as contact is made.
No. A barrier must be six inches thick to entirely end the sound. A condom will only diminish the sound proportionate to that, so only by a decibel or two.