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.