If you think that being a plumber or an electrician or a mechanic never requires creativity and deep knowledge, then I think you are looking down on those professions a bit too much. Much like programming, most of what those fields involve is routine grunt work. But from time to time, the usual ready-made solutions don't work and you'll have some tricky problem to solve.
I don't think that's true. If your job is checking off Jira tickets maybe it's the case. But there are plenty of areas where you need a lot of creativity and deep knowledge to make progress.
Exactly. There are plumbers who just execute exactly what they learned in school but nothing else and there are others who can solve tricky problems. Same for programmers.