Is there any significance of booze/getting drunk?
Pirate Rum is completely useless, it just blurs your screen for a while.
However, the other alcoholic drinks (Wines) in the game do have a use; they're potent HP/MP potions. They're dropped by enemies in Oryx's Wine Cellar though, so they're rare and hard to get.