For most social situations I'd say that yeah, your spouse should make an effort to attend with you (assuming you were understanding if he didn't do it every time, or had to bail early). I do this for my partner quite a bit. The NT in a relationship should not be the only one to put their wants aside from time to time.
Church, however, is one of a very few (so few I can't really think of any others; maybe hunting or something) social events where I think a partner (any partner, aspie or NT) should be able to say "no" and have that be the end of it.
_________________
If life's not beautiful without the pain,
well I'd just rather never ever even see beauty again.
Well as life gets longer, awful feels softer.
And it feels pretty soft to me.
Modest Mouse - The View