Ohhh it's definitely good after a few drinks, it's just waking up in the morning that sucks hahaha.
For anyone thinking of doing this, I recommend buying a futon mattress instead of an air mattress. I got a smaller size futon mattress from ikea for $100 and it fits a lot better then a double size air mattress. And you don't have to worry about waking up with a deflated mattress.