No it is good for humanity, but not necessarily good for individuals who built technical foundational skills on things that will be taken over by automation.

AI as it is now and as it will be projected into the future WILL automate many skills. But not all skills. MANY MANY people will retain skills that cannot be replaced by AI. One career track that will be replaced is definetely the SWE. Or at least massively reduced in capacity if not eliminated all together.