Here's my take:
If you place a premium on pleasing everyone around you all the time, you have effectively taken away your own agency and given to them. You are under the control of everyone else's emotional reactions. That's not mentally healthy for you, nor is it good for achieving your own goals. It also makes you a giant target for the kind of emotional vampires who prey on people like this.
At the same time, if you simply disregard the consequences that your actions have on the emotional states of the people around you, you become a selfish sociopath. Remember, for every Steve Jobs and Elon Musk, there are a million petty assholes who make the world worse every time they open their mouths. If you are unlikeable, the odds are very much not in favor of you being a visionary genius. You're probably just that jerk that no one wants on their team.
If you are choosing to be unlikeable because you think it improves the chances of you being great, I think that is a sign that you are less likely to be that. Real visionaries don't decide to be unlikeable. They are unable to be likeable because they are so consumed by their passion. Opting to be a jerk is not going to magically create space in your life for brilliance. If the brilliance is there, it will have already driven out the compulsion to be a constant people pleaser.
The advice I would give is this:
1. Surround yourself with a small group of trusted friends and family whose regard deeply matters to you. These people exist to help maintain your moral compass. If you do something they don't like, you really did fuck up and you want them to hold you accountable.
2. Try to be a good person who improves the lives of all people you encounter. Default to likeable.
3. Sometimes you will have to make choices that harm some people. Pay full attention to the cost to those people and make sure the benefits to the world and not just yourself clearly outweigh it.
4. Accept that some people simply won't like you through no fault of your own. These people are relatively rare. If you find yourself frequently placing people into this category, reflect that it may be you who is the asshole.