The few times I have seen SO recently have been from friends trying to do Linux things, looking for answers on SO, and finding some ludicrous answer that is either just wrong or an extremely roundabout (and overcomplicated) approach to solving it.
So my guess is that SEO is what takes people to SO first, even if it might not get the best results. (And sure, some of that search ranking is due to people recommending it left and right for real: it is actually organic and not fake)
I've long ago accepted that my brain doesn't like learning how most others seem to (I also don't like flowcharts, and prefer dense reference material) — this is not to discredit their way of learning, just recognizing the differences.
I've also built this search engine from scratch: https://search.marginalia.nu/ , not once did I consult SO.
You could argue that if I sucked it up and read the man page a few more times, I’d stop needing awk. You’d be right. But I don’t have your aversion to SO, so it’s not so bad for me.
Feels like going to the 13th century catholic church for answers: The answers are as old as they are doctrinal and detached from practical reality, whereas my practical experience is that the honest answer to almost all programming related questions starts with "It depends".
The fact that the medium is set up for each question having a definitive answer just doesn't seem to be a great fit for the open-ended nature of programming questions.
I think stack overflow is mostly a series of training wheels that you can simply grow out of.
For example, I no longer use Stackoverflow since they started showing these pop-ups, ostensibly to force me to accept what I regard as an invasion of privacy. When reading a web page, I would like to be able to concentrate on the content without any distractions, and my feeling is that a site that shows pop-ups does not respect this sufficiently.
As to solutions: Wherever I can, I support all measures that let a website get rid of any existing pop-ups, for example by advocating for less tracking and more respect for users' privacy and ability to quickly obtain the information they want.