take your time and find a good replacement. The reality of this job takes awhile to sink in. Don't beat yourself up over one failed checkride. That one event does not sum up your entire flying career.
you need to do what is best for you and your family and if that is leaving so be it . Good luck there are a lot of possibilities for someone young and with your education level.