People think it's spiritual simply because it contains the word "hallelujah". What's even more ignorant is the use of such a maudlin tune for the Hallelujah, which is by definition an expression of rejoicing.
I am one of the funeral coordinators at my parish and our priest hates “I did it my way” that’s one not allowed at a funeral.