The wireframe is just to make the movement visible or it would look like a static object as its texture offsets to face the camera. You are right about that the predefined UVs are preserved, and this is a desired behaviour. I’m not targeting to the sphere geometry, it’s just so far what I can achieve which is able to express my attempt.
It’s more like what we can do with the unwrap UVW modifier in 3DS Max as the following picture shows:
In this picture I intentionally made the sphere polars align to the horizontal plane and keep the texture’s up the same as the camera’s. I’m not sure if the offset/repeat/center/rotation parameters of the texture are sufficient to get this solved, but I suppose it would be as they eventually affects the UV transform. So I think I’m basically trying to move the texture’s coordinate no matter the geometry of the mesh it binds to.