When was the last time this " ideal father" worked and provided for his family?
How long has his family been financially contributing to his cause?
A good father works full time or multiple part time jobs to provide for his children unless the arrangement is for him to be the stay at home dad.
A good father does not steal from his family.
A good father pays the rent.
A good father puts the welfare of his children, before his own.
You knew going in, that he was once addicted to heroin, regardless of how he injested it. At that point, no doubt, his parents also thought addiction was the past.
That you are concerned about being hated by someone who consistently put himself before you and his children is not healthy for you. Like him, you have choices, too.
What can you do for you? Ask for financial help and get the rent paid. Are his parents in the area? Can they watch the babies while you attend Alanon or Naranon and start the process of healing yourself ? Your mom? Social services? What options do you have for employment?
My heart aches for you and your situation. Please know you did not cause this. You cannot control this. And you cannot cure his addiction. He does not use heroin because of anything you did, or not. It's his demon and only he can beat it.