A little weed in moderation clearly helps him bond with his very young children. If I were him, I'd be concerned about coming to rely on it and about how my toddlers would perceive me as they got slightly older. Kids are very perceptive and they will notice - and worry - when daddy is unusually attentive, imaginative and happy (and glassy eyed.)
Provided his wife remains sober to drive the kids to the ER if they need it, and assuming daddy's stoned playtime with the kids doesn't interfere with his other responsibilities at home I don't see all that much wrong here at the moment. What he's written here is all positive, but then all drug stories start that way.
Can you please explain what you mean by this? What I got from this article is that he was stressed to the point of not being able to sleep on occasions and that he felt his relationship with his children was not what it could be; he found a way to address that.
It feels to me like a "sorry excuse for a parent" would be someone not considering their children's wellbeing; but this seemed to be one of the author's main preoccupations here.
Is he hurting his children in anyway?