How do I cope with being a dumbass?

I am dumb as hell and I really hate that, because I was taught to pride myself on my intelligence. I am exceptional when it comes anything that involves music, art, or something in STEM, but other than that I am dumb as rocks. I struggle with:

Time management

Working smart, not hard

Navigating social situations

Dating

Planning my life

My parents stupidly had me believing I would go to Harvard or some shit without actually training me for it. They neglected me because they were too lazy to train me properly. These “types” of intelligence I listed matter imo, way more than excelling in some academic field or hobby. It really lowers my self esteem.