> I believe that fancy astrophotography tripods already do that rotation for you, right?
There are various types of mounts, and each type can be either basic or fancy. The specific type of mount that deals with rotation of the sky (around the north/south stars):