Not unusual at all. I'm a senior executive in tech and see this every day.
IME as a rule - and there will be exceptions to this - the best tech people will absolutely not make the best managers and vice versa. I say this as someone with a very technical background who made a reasonably good (but by far never the best) developer back in my day.
Having discussed this with lots of my colleagues, I've come to suspect that really good technical people (and I include profiles like e.g. technical BAs in that) need to have a certain degree of tunnel vision. I mean that in the most positive sense, as in: need to focus relentlessly on resolving problems in the technically most desirable manner.
Really good managers, on the other hand, will always want to look for alternatives and will base their decisions on business outcomes. E.g. just yesterday, I told a client that, while I liked making sales as much as the next person, I didn't really want to sell them technology X because their problem would just as easily be resolved by leveraging technology Y that they already have and save them a lot of money in the long run. It's not elegant and my developers are going to resent the fact that I talked them out of a challenging assignment but it's what's best for the client taking into account their mid- to long-term strategy and their options.
Long story short, I don't think one's better than the other per se. But I do think that good techies often don't make happy managers and vice versa.
So, OP, I'd recommend you go ahead and ask if a move to a different role is an option. Ideally perhaps some kind of senior SME type role where you still tend to get managerial level salaries but you can actually focus on leading on the subject matter and not on the stakeholder management and status reporting front.