As a trader, I can say that at least in Finance, the dead internet theory does apply. Type any stock ticker into google, especially a small one (random example: MRAM), not a single article for "mram stock" is written by a human, you have AI generated pages such as "stocknews.com", and dashboards like FinViz (which fwiw is a good and useful website). The articles are generally generated based on quantitative (and therefor easy to automate) aspects of stocks, for example price to earnings, or that the price has grown alot.
A second type of website exists, which I learnt of from searching tweets in google, and finding that algorithmic spinning (replacing words to avoid plagiarism detection) was clearly being employed. The grammar is often laughably bad, but clearly in terms of google is either the best content available (as their algos see it), or the only content available.
One more Note: Google Trends data is 'deflated' to the number of searches (you can verify this by using Google Ads which gives numbers of searches and comparing to trends data). I assume the method is similar to what is in use for the transparency report's "censorship / outage" feature (explained here: https://transparencyreport.google.com/traffic/overview?hl=en)