In British journalism, tired and emotional means drunk. It became famous in 1967 through reports about George Brown, then Foreign Secretary. The earliest known use as a euphemism for drunk is in The Guardian of 24 August 1967. On 29 September 1967, Private Eye wrote: “Mr George Brown had been tired and overwrought on many occasions.”
A popular story says that the phrase was first used about Brown after the assassination of President Kennedy in 1963. No evidence for this has been found.