How do master modes, especially NAV mode, work in atmosphere? Is there any reasonable change to how they work in atmosphere?

Nope. So it's going to fly the same as it does currently. So if you take a ship in NAV mode into atmosphere, you're going to suffer the same drag consequences of that. And then if you switch to SCM, you're going to be limited to those speeds.