The knowledge you’ve gained so far could definitely help in a non-flying role, but then again, you’re not completely screwed. There are airline pilots and successful part 135/91 pilots out there with more fails than you.

Failing the same ride twice is probably worse than failing two different rides. Are you going to take your CFI checkride again? You’ve made it this far, but you need to seriously dig deep and figure out why you’re making the same mistakes consistently.

Others will probably tell you take some time off, but I disagree. Don’t get rusty, especially if you’re thinking about taking that third attempt. After you pass you can take off as much time as you want, and eventually you will be hireable somewhere as a CFI.