Where do we go? There always have been the frontiers of computing, this is where CS sepcialists are required. The old saying, that an IT guy works hard on making his own position superfluous, has always been a bit true in some sense. I don't think that's bad at all.
I which computer scientists would be aware of their competences but could acknowledge that they never gain as much domain specific knowledge as the experts they work together with. I've seen quite some computer science guys who thought of themselves like they could replace everybody. That's not quite true.
But it’s proven almost impossible to achieve it because people just don’t get it. We’re talking about PHDs in economics who can’t wrap their heads around a for loop.
I’m sure they could learn if you gave them enough time, but no one is going to do that.
Software engineers will still be around as the people who will take code from other professionals and work with them to turn it from a prototype into a production ready codebase. That means unit tests, fixing performance issues, building in security, building proper UI/UX, adding things necessary for regulatory compliance (e.g. accessibility, GDPR, etc.) and so forth.