Different people have different reasons for going to Mass. Even the same person, at different times in his life, might have different motives and varying levels of motivation.
Let me begin with my own story. I am not sure how relevant it is to your own and your husband's story, but who knows? Following that, I'll write up some ideas for you. That may get into another post or two because of the length.
When I was a child, I was brought up in the every-Sunday-come-hell-or-high-water tradition, and for many years that was a good enough reason for me. As I recall, I went to Mass primarily because it was an obligation.
That continued at least until I was in my twenties, and then Sunday Mass took on an additional significance as a social framework. I was in wonderful campus Catholic communities that, of course, were geared for young adults. At that time I was beginning to think more about my relationship with God, doing a little Bible study, a little prayer. Those were very good years.
My Sunday Mass routine broke down when I was 28-30 years old, shortly after finishing my studies. I had moved to a new city, and found myself in a parish that appeared to be slowly dying. Most of the congregation were old ladies. The pastor's homilies were generally gloomy. Imagine, if you will, a sermon about how life is empty and meaningless, so our only hope is in God. That may play well to the widows, but not to a young person full of hope. I tried another parish across town, but it was just too new-age, politically correct, and spiritually listless. Sad to say, I gradually dropped out of Sunday Mass, except for family gatherings and holidays.
What got me back was having kids. My wife and I are both born-and-raised Catholic, and yet had both dropped out for a time, though we married in the church during that time. We had children and wanted to raise them to be morally upright and strong, etc., and realized we couldn't do it on our own. We needed the structure and community of the Church. Our kids were baptized. We discovered that our new home parish is full of life and spiritual energy. I somehow stumbled into a men's catechism and scripture study group that has re-ignited my Catholic faith. Now when I go to Mass it has more significance to me than ever before. I appreciate and enjoy each and every prayer, song, and rite.
I still have a ways to go. I have occasions of sin and moments of doubt. Yet I am closer to God than ever before. Let us pray that I do not stray too far or too often.
Luke 15:3-7, Parable of the Lost Sheep
Here are a few thoughts about your situation:
I wonder if your husband experienced a bit of a letdown upon leaving the campus Catholic community, as I did. See if your current parish has some programs that would work better for him. Depending on his personality, this might be a Bible study group, a volunteer service group, or a men's group (I'm not thinking of the Knights of Columbus, surely a fine group but perhaps more of a commitment than he's ready to make, but a men's study group like the one I participate in, or whatever, maybe a men's cookout club?). Anything that gets him engaged with the parish community will be a good influence.
By the way, if it is just the Mass that he objects to, perhaps you can persuade him along the lines of "Well, you can't quit the church entirely. The (Bible study or whatever program) would be a good way to (get whatever it is he hopes to get out of it)."
Perhaps your parish offers Why Catholic?, a study program based on the Why Catholic series of workbooks.
My parish has occasional showings of the Catholicism video series. See if you can find it at your parish. I highly recommend it. This is not your typical watered-down TV "infotainment." It is very informative, visually appealing, and (for me at times) inspiring. You could purchase it on DVD (but do shop around for a good price), and I see that there is an accompanying book that may even be available through your public library (I just checked, and my town library has it).
If you think your current parish somehow just isn't meeting his emotional, social, or spiritual needs, perhaps the two of you could visit a neighboring parish.
Oh dear, it is getting late. I'll write more another time.