It's because there are actually two different forces at work here. The merry-go-round effect is caused by centrifugal force, which repels things from the center, while gravity is instead related to centripetal force, which draws things toward the center. ...