A top detective said “I'm f***ed, I'm f***ed” when an unmarked Garda car he was driving crashed on the M50 motorway after he had spent hours in a pub, a court has heard.