"But AI will just be a tool in our tool-set, software engineers will still be the system architects."
Sure, for a while and then AI will do that too.
"But eventually we will live in a fully automated world in abundance, wouldn't that be great?"
Doing what? When we get there, anything we can consider doing, an AI can do faster and better. Write a poem? Write a book? Write music? Paint a picture? Life will be like a computer game with cheat-codes, whenever we struggle with something, instead of fighting on and improving we will turn to our universal cheat-engine: AI.
Anecdotally, I did an analog mistake in my early twenties when I wrote a cheat-program for save-files. It worked like a typical cheat-engine, search the save-file for a specific value, go back to the game and change that value, go back to the save and search for the new value but only in those locations that had the original value. This is how I ruined "Heroes of Might and Magic II" :(. I used to love that game. I could spend hours playing it. Writing the cheat program was a lot of fun for a couple of hours but when it was done, there was no longer any reason for me to play the game. You might say that I didn't need to use my cheat program, but once the genie was out of the box it was too tempting to resist when I met some obstacle in the game.
This is what I fear about AI making our jobs superfluous; it will also make our hobbies or anything we enjoy doing superfluous.
Sorry for the bleak comment but this my fear and I feel the genie is already out of the box.