Lizzy79, welcome to the board!
Just keep playing for your husband and invite him to go to church for special programs w/ the children. I went through a period of time similar to you when my sons were young, it was easy taking them to Sunday School, but sitting through church with 2 little boys was very distracting and trying (even with the little story books, cars, crayons, etc). DH had faith, just had issues with the church for many years. He would come to their Christmas programs or special events maybe once a year.
Finally, we changed churches, due to our sons going to a Christian school rather than public, and when DH found the tuition was less expensive if we became members, he agreed to start going to the new church because it hit him in the checkbook.

! Not the reason to go to church, but I think it was God giving my DH a nudge in the right direction.
My older son was age 7 at the time of the change and, now as an adult, does not recall the time when Daddy did not go to church w/ us. He does recall the 1st church, but not that his Daddy did not attend too. DH attends church and has now for a number of years.
Keep praying. ((((Hugs)))