Sir Anthony Hopkins knew he needed to get help for his drinking when he realised he "could have killed" someone while driving during a "blackout".