Thank you all for the responses, I guess the truth is that "it depends". I've got a tough decision ahead of me and have the utmost respect and admiration for everyone in the community.
Honestly what it's going to boil down to is if you're there you should want to be there. Flight school isn't fun, it's miserable if you don't want to be there.
From an IP prospective, you can always tell the guys and girls who don't want to be there but are to afraid to DOR... usually they're not all that good skill wise and teeter along at the verge of attrition and have no enthusiasm for the endeavor... we can't just attrition them arbitrarily so we have to throw time and resources at the person until they finally pull the plug or attrite months down the line. In every case they're very relieved when they're finally out of training and moving on with their lives.
My best friend from college HATED flight school and flying... Her dad was an old school SPECOPS type so she refused to DOR but she was miserable throughout flight school, her first fleet tour and her shore first shore tour because of not DORing, and she freely admits she was a pretty terrible pilot and says her JO flying tour was the worst time of her life because she was miserable. The first time she ever enjoyed being in the Navy was her boat tour away from flying... like seven or eight years into her career. She didn't take the aviation bonus and After she non screened for fleet DH the Detailer offered her a VT OP-T DH slot... she turned it down in exchange for a dead end, non flying Job and ultimately got picked up for a non flying community lateral transfer and is much happier, 12 years later.
If you seriously don't want to be there, please save everyone the time and headache of dealing with you being there but not wanting to be there. Save yourself the misery as well. You're not a bad person for discovering you don't want to be there, don't let fear dictate your life.