Am I ever gonna get over the self hatred?

Overcoming self-hatred is a challenging and deeply personal process. It often requires a significant amount of time, effort, and support. The first step is acknowledging and accepting your feelings, which it seems you've already done by recognizing your self-hatred.
In addition to professional help if you so choose, practicing self-compassion and self-care can be beneficial. This includes treating yourself with kindness, understanding, and patience, just as you would a close friend. Engage in activities that bring you joy, help you relax, and promote a sense of well-being.
It's also important to challenge negative self-talk and reframe unhelpful thought patterns. Notice when you're engaging in self-criticism and try to replace those thoughts with more balanced and realistic ones.
Recovery from self-hatred is not a linear process, and it's normal to experience setbacks along the way. Be gentle with yourself and remember that progress, no matter how small, is still progress. With time, support, and effort, it is possible to develop a more positive and compassionate relationship with yourself.

When in a low mood, it might be helpful to mentally run through a list of mood triggers to see which one is driving your thoughts at the moment. Feeling low and not knowing why can be a difficult place to escape from. Knowing what took you down that path can be dealt with logically.

I recently read a study which posits that those who spend a LOT of time deep diving into THEMSELVES and their own feelings are almost consistently miserable.

The same study posits that those who think about others, and about how they can help other people, are almost consistently peaceful and content.

You have a choice — continue in the manner you have, or choose to recognize your value and worth. It is a choice you make every single day, and you have to do it until it becomes muscle memory, instinct. It isn't easy at all, but one choice is to be OK with that, to get back up and climb into the saddle.

You will never be able to get over, if you keep going down the road that you are going. What you need is a U turn.

Though we have been forced to live and fend for ourselves in life, much against the wishes of nature that created us for each other, we can realise and turn about.

Our eyes were made to see others and not ourselves. Our hands can only hug or embrace another but not ourselves. We can lift someone with our hands but not our own self.

So start taking care of others and be under others care, is the Mantra. Not letting anyone to care for us, is also selfishness.

Try this retrograde in life.

You could try seeing a therapist.