Not everyone is cut out for church.  

I do think it's too much to expect a 6 year old to put aside his vehement resistance in order to make mama happy.  That's a pretty sophisticated behavior.  He might be able to do something to make you happy, but if doing so will make him miserable -- that's something many grown folks can't quite muster.