For a very long time people will also still need to understand what they are asking the machine to do. If you tell it to write code for an impossible concept, it can’t make it. If you ask it to write code to do something incredibly inefficiently, it’s going to give you code that is incredibly inefficient.
In the long-term yes, but in the short-term and even medium-term, housing takes time to build, so there’s going to be a lag. During that lag, it can cause problems even without NIMBY policies.