It seems that you posted this AIBU request at the end of a long and frustrating attempt to get your OH to try and see things your way.
There are a few things which IMO, are making this more difficult for you and the family. Having a discussion and stating 'I hope that xyz' is very confrontational - whether you meant it or not so maybe it's not surprising that DH took it that way.
With regards to family time and church:
Make the kids go too. If they're too young to stay home along for half an hour whilst you pop out then they're young enough for parents to make some decisions for them. You tell DH that if he wants to go to church every week, he takes the DCs and so it's in his best interest to find a shorter sermon time and a church that has interesting children's part of the sermon - whether separate or with main congregation
Tell him he needs to compromise on service length I actually don't know of any churches which have services longer than an hour - nowadays they are usually around 45 mins unless there's christenings or similar
Alternate his church service days/times there are early times and alternative days - usually Saturday evening
IMO there's more to this maybe because he works away, he's not go a good friends/social base outside of family. Church kills 2 birds with 1 stone. He feels good (I know what he means - I'm not as regular as I used to be but when I do go to church, I feel so much better afterwards) and he gets to see the same people regularly - and congregations do usually tend to be friendly at the service and the 'social' afterwards (which usually only lasts 15 - 30 mins)
May I also be bold and suggest that you not pour all your frustrations into one event - as you have shared, there are other problems which seem completely unrelated. Putting them all in the same basket will not help.
Best of luck.
PS - YABU to ask someone to change something as personal as needing to go to church, however YANBU to expect DH to compromise and work his needs around those of his family which, at the moment, he does not seem to be doing.
PPS - You've stated your frustrated, hence some of the aggression, however most of it seemed directed at people who did not agree with you. AIBU threads are not the best place to start some discussions - maybe this was one of them?