I mean, "north" in the context of software that's taking you places is rather redundant. Does it really matter if your next left is taking you north, south, east or west?

That being said, at least in Apple Maps, when you stop using the turn-by-turn and the map zooms out, it does auto-orient to North being "up." I'm not sure if Google Maps does the same but I see no reason it wouldn't.