It's really wonderful that your child can come to you and share those feelings. I had many thoughts like that as a child and never felt comfortable enough sharing them with my parents.
I'm not an alcoholic, so I have no advice on how to cope without alcohol, but I hope you can forgive yourself and move on from your slip-up.