I've been managed by truly brilliant coders who just wished they could go back to sitting in their office and code. No one was happy with that situation.
As for motivation (I know no one asked): I genuinely enjoy the human aspect of the job and thinking further out into the future with product and engineering leaders. Plus I learned that I really enjoy programming when it's a hobby without the corporate overhead, and that it's less fun (to me) in a company.
Not to discredit your experience - but it's not a universal truth.
Cases where managers are appointed to oversee dev teams without having any engineering experience at all are more common in non-tech companies. Those situations can still work, but rarely work well.
That is, their capability to manage.
It should be MAAAM by now- Microsoft is famous for the IC rest-and-vest to ‘55 lifestyle.
The former does not follow from the latter.