For example UI design can be replaced by AI. Unless UI or UX design people were bringing something like _taste_ instead of simply mechanically operating figma - they are not keeping their jobs.
I genuinely don't need to learn SQL ever in my life. I just don't need it for dashboards or analytics use. A person whose main job was to translate requirements to SQL into a dashboard and nothing else would not keep their job anymore. The person to whom they were providing the analysis to could just perform the analysis themselves using AI.
I do think that most jobs would change dramatically but for sure some of them would be eliminated completely.