doodlebrained

adj.

Drunk in a way that turns misplaced confidence into a complete working theory of the evening.

Zubin got doodlebrained and explained why missing the last train proved the journey was unnecessary.

Source: Wiktionary