The best product managers I know seem to have a natural talent for it. And plenty of them found their way into it by accident. Maybe they were working in another part of the business, but realized that they had a knack for understanding how the product could be better. Maybe someone told them that they would be good at it.
My take on it is that yes, lots of people want to be involved in tech, but don’t know how to code. Product management is a Way to do that that’s accessible to non-engineers. Some people will try it out and find that they have strong abilities at it, and many will fail at it. But I think it is seen as a desirable job.
That said, I think it’s an incredibly hard job as well. You have to deal with people above you constantly pushing on deadlines, you have to stay super on top of things, and you won’t succeed, unless you earn the respect of the engineers you work with. It can be very demanding. Most people don’t seem to have the skill set for it. And if you are in a company with a bad culture, it can be a very thankless job.