I'm sorry to hear about the difficulties you're facing, but unfortunately this is more than a silly mistake. At that level of intoxication you are quite fortunate that you did not injure yourself or anyone else. What would your child have done without a parent?
Magic will not resolve this problem for you. Only assuming responsibility for your action, learning from your mistake, and perhaps, public transit.