Rotating space elevators: Physics of celestial scale spinning strings