What astronomical phenomenon causes the entire celestial sphere to appear to rotate opposite to Earth's movement?
The Earth's rotation on its axis approximately every 24 hours.
The apparent movement of the stars across the night sky is not due to the stars themselves moving in circles overhead, but rather due to the observer's movement on the surface of the planet. The Earth is continuously spinning on its imaginary axis, completing one full rotation in roughly 24 hours. This rotation results in a constant shift in the observer's frame of reference. As the observer rotates eastward with the planet, the celestial sphere appears to move in the opposite direction, leading to the observation of stars rising, setting, and tracing arcs across the dome of the sky.

#Videos
Why is the North Star Always in the Same Place? - YouTube
Why Do Stars Draw Circles Around Polaris? - YouTube