CarPlay is merely the technology of having your phone take over a screen in the vehicle. It’s not a mapping map. Plenty of mapping apps support north up.

But in any case, I found that if you want to remember routes, it is far better to study the route before you begin driving, and then not rely on CarPlay altogether. This gives you much higher awareness of street names and directions.