I thought the song was respectful, especially in light of his previous comments, but you could be right. I don't know enough about Keillor to discern a sarcastic meaning to the song.
He sings many hymns to very kind ole devout religous people. There isn't any sarcasm in it.