If that results in a gradual erosion of quality as less and less effort is put in to researching and writing articles, and more and more of the content is churnalism or opinion pieces, then it's a net loss for everyone - eventually the adverts will be more interesting than the real content which lives in the interstices of advertising - I think that would be a shame. I've seen that happening in major newspapers in the UK like the Independent or the Guardian. We've seen the same in television with the rise of Reality TV etc - cheap to produce, controversial, and the perfect filler to squeeze between advertising segments.
At least with regards to written content, most people have access to much more interesting content. Heck, hn is more interesting than my newspaper. And we manage to find stuff to talk about.
Investigative journalism is just a case of the tragedy of the commons, that now run out the huge luck it got n the past. And we as a society need to start looking at it as such, and not fantasize that it is a standard business.
The real reason is not really that people don't want to pay for it, but rather it's available for free, so there's no need for most people to pay for those things. If there were no free travel guides etc., people would still pay for them.
A comparable situation is happening with newspapers. People will pay for news if they cannot get them for free. Since you can these days get news for free, a lot of people are getting rid of their newspaper subscriptions.