It makes sense to write code by hand.
We are in a hype bubble and it can be hard to go against the grain. The bubble will calm down, as it has every other time: crypto, low code, outsourcing, SPAs, Java, AI that last time around (search for Lighthill report).
I agree with your concern about skill stagnation or erosion. Years ago we used to make fun of "architectural astronauts": developers who stopped implementing and instead used English to design systems for others to implement.
I'm guessing you have had the experience writing code where you throw away the first, second and maybe third implementations? While you "work out" what the real problem is? Our human brains need that niggling at the problem before we can make a good design. Don't short circuit it.