I think Indy would have to be pretty darn drunk himself ;) Hard to imagine him not being straight.

But waking up with a snake in his bed... that would be a damned amusing scene, especially when said snake turns back into a supposed-human. Thankfully Indy's seen his share of mystical stuff.