Well, the good news here is that failure is kind of a packaged deal with life.
If the guitar pedals you build don't work, I guarantee you that there is an identifiable reason WHY they don't work.
And that reason has nothing to do with who you, personally, are. Nobody's uniquely blessed with a supernatural ability to fuck up every build for forever. Nobody is invariably doomed to be shit at building pedals for forever. And, truth told, nobody gets to success by themselves.
My dad taught me to solder. I have countless individuals online that I owe my gratitude to for sharing their knowledge for free. I work in a field that taught me LOTS about electrical theory that I wouldn't know otherwise.
90% of errors, when it comes to putting a pedal together, comes from incorrect wiring, shorts from solder bridges or wire whiskers, and reverse polarity on polarized components.
If you're consistently building pedals that don't work, you're likely repeating a specific mistake. Maybe you've got your center on 9vdc wired to positive. Maybe you have your inputs and outputs reversed. Maybe you're wiring your 1/4" tip connection to ground.
Maybe you're using a switched power jack, but you're connecting your positive lead to the wrong, switched terminal.
That's what the troubleshooting forum is for. Just take good pictures, follow troubleshooting forum etiquette, and if you don't have one yet...buy a multi-meter. Build an audio probe. Learn to read schematics.
You don't have to know everything instantly. Hell, that would rob you of all those "ah hah!" Moments that can rejuvenate you and lead to an immense sense of satisfaction.
But...this requires patience and an ability for self reflection. To troubleshoot, you must first accept that you probably made a mistake, and that mistake exists independently of you. Your ability to debug it or not relies entirely on your current skill level, which will change over time, and does not reflect your potential.
TL;DR, chin up brotha. Have fun. If you're not breaking anything, you're not doing anything.