100% , AI should never be placed in a position where it makes all the decisions itself. Even if it can make the descisions doesn't mean you should let it. A manager is required ,that was said correctly by paul graham.
Also whether you need to learn CS depends on your goal , if you're someone who have to work in corporate or in a company then learning CS is still required.
But if your only goal is to make something using your own creative ideas then not learning CS is valid.
But it also depends on what kind of person you are. For me example i only started using AI to speed up my working once I understood everything. Some people hate completely depending on something or someone which leads them to learning the skill so they can stop depending.