Hi painfree and welcome to SR!
Your concerns are valid and wise, my dear!
There will never be a guarantee he will stay sober the rest of his life. I've been around the halls of AA since 1986, and I've seen many go back out the door to never return.
You said emotionally he supports his children. Does he also support them financially?