There seems to be a lot of "he wants" here, and the "he wants" is what got him in trouble in the first place, yes?
What you want makes more sense. You want a program about taking care of yourself and how to live your life in a healthy way. He is mistaken about Al-anon, it's not about him at all...maybe that's what bothers him.
You also want to protect your child from hearing stories that he doesn't understand and that may scare him. I've been to AA and NA meetings and the stories can scare me sometimes, so I can only imagine the fear a child would find there.
When he doesn't get his way, he wants to end it all. Do you hear a 6 year old here?
Sweetie, do what is right for you and your child. Live the life you should be living, one filled with happiness and joy. You deserve better than the life you have today.
Hugs