I find this very interesting (your experience MarasmeAbsolu and the one of other posters as well) and how that led to the decision of not passing your mother tongue language to your child.
I can of sort of relate to it to a point. I had been living away from my country for almost 10 years by the time my DS was born. Four of those years in an English speaking country (England), the other five in Japan where English was very useful and the language I used the most to communicate when I struggled with Japanese.
By the time my son was born, I was used to thinking in English 90% of the time. I only used Spanish when I communicated with my parents back home. I didn't know how I was going to be able to pass on my language (Spanish) when English came so naturally to me and I had forgotten many of my words in Spanish or there was a whole new context of baby words that I had not used when I used to live back in my country.
I suppose I was lucky that my mum came to stay with me the first 9 weeks after the birth. I talked to her in Spanish all the time, and I heard my mum talking to my son in Spanish all the time as well, even the baby talk. By the time she left, I had already got used to seeing my son as a Spanish speaker, and could only talk to him in Spanish. English felt out of place with him.
By doing this, eventually it felt less of an effort. And by reading books to him, finding DVDs in Spanish, and as many opportunities to practice Spanish with him, my Spanish came back again and it felt natural.
I guess everyone's experience is difference, but raising a child bilingual is by no means a given thing. I have found that it takes a lot of effort and investment, and can only come from a very strong determination and will to do it. Having said that, even if you give it your best shot, it would also depend on your child and not all children have a love for languages.
Anyway, for the OP, you cannot force your husband to speak in French to your DCs if he doesn't feel like it. But you can help by creating as many opportunities as possible (all the advice previously given is spot on, TV shows, DVDs, Youtube, books, French clubs, etc) and this in turn might help to make it easier on your husband so that it becomes more natural for him to talk to them in French.
Good luck!