I think another issue is "birds of a feather" related. Unless you've got a wide personal circle (or force one) the people you're talking with most with have the same engineering view and can form an echo chamber of flaws and technical issues. They may be valid but they probably aren't that crucial.

When that happened, we started hiring, and me coding turned into more of a detriment than an advantage. It was approximately a team size of 7-8 for us/e.

Under pressure and suffering uncertainty, the Can Do attitude of a good engineer encourages falling back into the comfort zone of doing engineering. It is understandable. But whether manager, director, VP, or CEO, the urge must be resisted approximately always.

It is probably forgiveable at the manager level. But this is still what I call a "Good Skill, Bad Habit", even for managers.

It is OK if you are sometimes not sure about something, or if you find that you have focused on the wrong thing. It doesn't follow that you should find a different job.

It does mean that you are capable of self reflection. It probably means that you are learning.