There’s still a lot of place for both. Because they are just a shift of perspective around the same thing: Solving a problem for someone.

Product is when you’re seeing things as the one who have the problem and designing the solution in a way that is usable. Technical is when you shift to see how the solution can be implemented and then balancing tradeoffs (mostly costs in time and monetary resources).

While the code is valuable (as it is the solution). Building it is quite easy once you have a good knowledge on both side.

The issue with AI is not in their capabilities, but in people rushing to accept the first version when there are still unknowns in the project. And then, changes costs almost as much as redoing the project properly.