Basic Physics: circular motion is created by acceleration constantly perpendicular to the direction of motion. For a satellite, this is caused by gravity that pulls the satellite toward the center of the earth as it goes around the earth.
For a brick in a bag with a rope (or on a platform, with a rope) you are pulling on the rope. The other trick is to spin a bucket full of water on a rope. For this trick, the problem is a bit more complex - apparent gravity wows as the bucket hits top - centrifugal minus gravity - and bottom - centrifugal plus gravity. spin the same bucket in a circle over your head, the water level will stay slightly tilted - downward gravity plus apparent (“centrifugal”) gravity.
But, you say, where’s the acceleration? The acceleration is the force you exert to stop the bucket from flying off in a straight line, David-and-Goliath-like. You pull on the rope. with a heavy bucket, you even lean. that’s force. you are exerting force.
As you spin the bucket or bag, the air inside travels along - just like air in a car or train. As the station spins up the first time, it may take some slight breeziness until the inertia of the air is overcome, but air with low mass has low inertia - plus, most space stations will not be an open complete donut. There will be doors - so the air does not blow through. Think like a train accelerating - the air inside moves too.
However, air is a tricky subject. the air in a space station, moving or not, has 14psi.(assuming normal air). Here on this big ball of dirt, it takes a column of air about 100 miles or more high, all being pulled down by a 1G force, to stop air from flying off into space. (And notice too that, minus some weather effects, this air too rotates along with the dirt and water.) So a space station will be a pressurized container, and if a hole appears, that measly 100 feet or so of rotational “centrifugal” force will not have an appreciable effect on its desire to seek to equalize pressure with an area that is leaking into space. Close the intermediate hatches!
Also a note about that carnival ride. The fun part is to try moving your hand or head while the gizmo is spinning. You will experience Coriolis “force”. You are trying to move something in a straight line while the frame of reference is turning. It will flop in a different direction. Move your head, and hope you don’t regurgitate the cotton candy and hot dogs. Your inner ears are not prepared for rapidly changing frame of reference. (Ever been an a whirly ride and felt like upchucking? That’s the tiny hairs in your inner ear that contribute to balance. Shake them too badly, and they think you’re being poisoned and make you remove your stomach contents.)
In fact, Arthur C. Clarke said in designing 2001, they acknowledged that to get 1G in the Discovery spaceship, without Coriolis forces mucking up your inner ear to cause severe nausea whenever you turned your head, the wheel would have to be 300 feet in diameter. Since it obviously is not, they simply fudged/ignored this point. (It obviously is over 300 feet on the space station.)