I don't have a whole lot of information that is specifically what you're asking for, but I will share what I can.
I am prior service (retired now, actually), and using Tricare Standard for myself. Yes, when on Tricare Standard you can choose ANY hospital/provider you choose, with some caveats. Since I assume your DH is still active duty, your Standard cost shares will be either 25% or 20%. If you choose a provider/hospital that is IN network, you will pay 20% cost shares, and that is 20% of the *Tricare allowable cost* NOT 20% of what the provider/hospital bills you. Since they are in network, they have agreed to take the Tricare allowable charge as their fee. If you choose a provider/hospital that is OUT of network, your cost share will be 25%, still of the Tricare allowable charge, and Tricare states that they may charge you up to 15% (I think) over the TAC which is also your responsibility. On this part, I am little unsure of how that works...i.e., if they're not in network, how can Tricare in any way manage what they charge you? You will want to speak to Tricare about that, if necessary.
You can go onto Tricare's website for your region (North, I think for NC) and do a search for providers available for Tricare Standard and find out who's in network. You can also just choose your provider and call them directly and ask if they're in network. Same thing for the hospital you're wanting. The greatest thing of all about Standard, IMO, is that you don't need a referral or preauthorization for ANYTHING except in patient mental health or substance abuse treatment. Everything else is YOUR choice at YOUR discretion.
As far as NC, I was on Prime there because I was AD so I didn't have the option of Standard. I was stationed at SJAFB and had my first child in the hospital in Goldsboro, and it has ruined me on hospital births forever. I have not had the good fortune of being in an area where homebirths were readily available and accessible, so I can't be sure about this either, but it's my understanding that Tricare will cover a homebirth IF it's performed by a CNM, but will not cover them under any other qualification of midwife, so if there are any CNMs in your area that will attend homebirths maybe that is an option for you.
HTH, and best of luck to you.
Follow Mothering