My father, an avowed atheist, would have found the entire spectacle very offensive.
As to not being respectful to sincere Catholics -- I would to some extent agree, but state that unless the deceased really went against Church teaching (like Kennedy, T), I, personally, would not be offended.