Putting yourself under the authority of someone you don’t respect will make you very unhappy. If you can’t work for someone you respect, work for yourself.
It’s a terrible feeling to need someone you don’t like—whether at work or in any other area of life. Avoid putting yourself in such situations.