No. Air tight means that no air can pass through and water may be able to, but water tight means that no water can pass through and air may be able to.
Well, my girlfriend was tight, then as our relationship progressed, we got more physical. And eventually you "loosen" somewhat and it stops hurting to have sex.