Those sites all work exactly the same as StackOverflow and you can login with a single account. Just the rules regarding content are different. See for example https://softwareengineering.stackexchange.com/
There is also the Area 51 site for proposals for new sites: https://area51.stackexchange.com/
They're still around. They're smaller... and by being smaller they are more useful.
What Stack Overflow killed off was Experts Exchange and a smattering of forums. Some are still around, but they're not trying to be searchable. Reddit's /r/javahelp or Code Ranch - every time there's a question its posted as a new question. Few people go back to find old posts there, but then that's the way the community works... and it works because it is so much smaller than Stack Overflow.
IRC channels and Slacks have taken some of it, with all the downsides that comes with that.