StackOverflow has been immensely helpful for me. When stuck on a programming problem, I usually look for solutions on StackOverflow or read the framework/programming language's docs.
It's highly unlikely that StackOverflow will slowly die. It's a very MOATY service: strong band, and network effects.