The ratings continued to rise for TNG as the music was being diluted. Maybe diluted music was helping to attract the general populace?
Actually, and this is key, the general public who were turned onto TNG didn't care. At all. They didn't notice the music, good or bad. Most people don't. TNG attracted people who had no use or patience for the original series, it's the only Trek show to actually do that. I knew a lot of people at work who felt nothing toward Star Trek and had no experience with it aside from TNG. And at no point, first season or seventh, did they ever comment about the music. Except maybe to complain that the opening credits were too long.
When you have the popular audience, when you're a top ten type show, you're not trying to stroke your hardcore fans. They'll always be there. Instead, you're trying to hold onto the larger audience. Whatever fans of Trek or soundtracks think, Rick Berman was 100% correct in his decision because - again - the general public doesn't care about the music. At least, not as music. They care in a subliminal sense, as the score enhances a scene, but they are not running to record stores asking for the latest episode score. Background music is all part of the mix which they either enjoyed or didn't. It's completely out of their minds as soon as the episode ends. So rather than take a chance on alienating his "regular people" by pulling them out of the episode with loud Sol Kaplan like dirges (which, by the way, I love as a film score fan and a Trek fan), he directed the composers to make their music part of the sound design. That was his choice, the show racked up 7 highly rated years, and only passionate fans care about this stuff.
To fans, Rick Berman is worse than Fred Frieberger. To everyone else, he was the producer of the most successful syndicated drama of the era.