Yes, but to be more clear I mean you should do what you love. If you aren't good at being a CEO but you are at being an engineer it's probably become you enjoy being an engineer more. Why force yourself to become better at something that other people could be great at, and you don't want to do anyway?
You should never do what you love. You should do what works for you. I love fishing, but I would never hold it as a job. Programming works for me. I like it, its fun, challenging, and allows for a good lifestyle. Two different things.
We love those things that bring us pleasure, we like those things that allow us to do the things we love.
It's not a dichotomy - some people do make a living fishing and love their lives. Will you love everything all the time - no, but you'll still essentially be doing what you love.
Even though I'm from a technical background, I'm finding that I really enjoy the business side of things, enough that I would (and will) happily cut programming responsibility loose whenever I can find a technical CTO, or even a good lead programmer. But when there's no one you can trust with the work, and you know how to code, it's very easy and very tempting to spend an evening up to your elbows in code. It's safe and comfortable.
But if I wanted safe and comfortable, I wouldn't be trying to start a company, now would I?
Sometimes, you just aren't having a perfect view on what you are doing, and what you should be doing.
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.