Haha, nope. The links points to a table of contents after which you are on your own. The right link should point to a specific page instead, but the problem here is that postres docs are poorly optimized for search engines. If you click on the top link from google, you would see there's a notice that the page is outdated, with a link to a current version, but said
link is dead. It's not an issue I've ever experienced with mysql docs for example.
And yes, w3schools, despite how terrible it is, is still above the official docs because it is more popular with newbies. I remember a time when I just started, I preferred sites like it, because they were simple and on point, rather than technically correct and comprehensive like the official docs are. If you forgot the feeling, try learning math on wikipedia (assuming you don't have a math degree).
For the rest I cannot argue. Generated/AI shit is indeed ruining the internet and search engines giving up and joining them isn't helpful either.