Job Site/Culture Specific Question

I am applying to a position specifically in Huntsville, Alabama. However, if if were to get the job offer after interview, I would have to make a really tough decision;

  1. NASA has literally always been my dream job forever
  2. I am an incredibly well respected subject matter expert in my field with a large and supportive network within my current company and am also a people leader in my current role.
  3. I'm afraid it's like the saying "never meet your role model in person" (they end up not being what you envisioned, your world view is now a bit tainted, etc).
  4. I would be moving from the Midwest

I would be risking and giving up a lot for this. Can anyone tell me if it is everything I think it is? What is the culture like there? Is there mod time/schedule flexibility, are people nice to work with, is Huntsville a good place to live? Etc.