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.
Kim Scott wrote extensively about this in her book "Radical Candor" . Do yourself a favor and skip the video snippets and TED talks, and go straight to the book (so you don't get caught up on the click-baity "radical candor quadrant"). This is particularly true if you manage teams - or ever aspire to.
The author is a former Googler and used to report to Sheryl Sandberg during the early days, before going to Apple and working with Jobs and Tim Cook, and more recently with Dick Costolo on Twitter.
This is one of those books I wish I had read when I started my career. It would have saved me from so much pain and mistakes learned the hard way.