You can certainly acquire the skills to become a great manager, but it takes effort, and you'll feel miserable if that's not what you want to do with your career. Worse: the experience of folks who report to you will be a mess.
If you're not sure what entails to be a manager, a good introduction is "Radical Candor", by Kim Scott . Another one is is "Resilient Management", by Lara Hogan . Lara was a senior engineering leader at Kickstarter and Etsy, so her examples are a bit more focused on tech people managers.