The role where you're still hands-on on a team is sometimes called a Tech Lead Manager, and there is a ceiling to this role. The next step up is true Engineering Manager where you have to be able to talk to engineers on other teams and gather information without being familiar with their code. If you rely on direct knowledge of code in all circumstances you won't be able to effectively operate in an organization with thousands of engineers and millions of lines of code. This is super hard, and relies on deep experience in the trenches (preferably 10 years+), but it is the only way to solve broader organizational problems that cause projects to fail, and many eng months or years to be shitcanned.