Loss of career, time in jail and the utterly humiliating and disgraceful coverage from the Daily Mail and others.
I am no apologist for The Mail but be careful you don't go too far the other way. Transport workers who carry members of the public in their vehicles have a unique requirement regarding the level of alcohol content in their blood. Unfortunately, one of the tenets of justice is deterrence and for that to work, it must be public which is unfortunately, humiliating. I don't think the gentleman in question has been treated any differently in relative terms to the majority of train or bus drivers (or indeed, other pilots) who have been found in charge, or preparing to become in charge, of their vehicle.
He will begin his rehabilitation program quite quickly and probably be released in 3 months or so. That his career is over is not in question but he is in a position many others have experienced and hopefully, he will get the support of friends and family to help him in the coming months.