I wouldn't be too worried about a single check-ride failure. I got lucky and had good DPEs, but there are some real hard-asses out there that would go out of there way to be hard on the occasional decent pilot and probably would have had reasons to fail me on my private. Also they used to a do a two day oral on the CFIs like 7 or 8 years ago and passing was probably less common than failing.
With the limited experience of CFIs these days I think students are at a bit more of a disadvantage then when I got my ratings as well as many of my instructors had well beyond ATP mins and even back then there was the occasional instructor that wasn't that good.
Was your failure related to you getting nervous and not getting enough sleep before? I know some people pressure themselves and fly worse on checkrides than normal and I think that's pretty typical. You'll get more comfortable the more you fly and I think the flight school atmosphere can contribute to it. One of the best things for your confidence can be to fly with other pilots as everyone makes mistakes, but it's easy to sit right seat, sit there and just catch every little thing you miss and seem like an expert so don't be too hard on yourself. A lot of new pilots stress themselves out too much with things like radio calls and once they learn to relax things go so much smoother.
There are also many decent gigs out there. Not every pilot will end up at the majors and there are a lot of cool opportunities that you might find more fun or that offer a QoL that suits you better.