NPM has their online survey results. Pew people think it’s worse than the musicians do. And the grass is browner on the other side.
NPM attributes the difference in musician-pew perception perhaps to acoustics, and that may be true. Church musicians might be a more forgiving lot and count the swell of sound on those favorite chestnuts as a high point.
As for the preference for home parish singing, again, it might be the memory of those inspiring times (few or not so few) when the people raise the roof with a good sing.