What you described are senior developers and system architects.

Junior developers spend most of their time writing code (when they're not forced to attend pointless standups, because Agile/blah/blah)

> The developers who still think their job is about writing code will perhaps not have a job in the future.

So you're saying the same thing everyone else is saying. SWEs won't go away, but they will be greatly reduced, because those whose job is about writing code -- junior devs -- will be replaced.

(How will Sr Devs in the future be created? That's the question, isn't it.)