When we see the bodies pinned against the wall, it is tempting to imagine that there are some centrifugal forces pushing those people outward against the wall. But there is none. The motion is fully explained by the presence of a centripetal force, not a centrifugal force.
The same principle is being applied by these stuntmen. The key to pulling off this stunt successfully is to ride at a high speed. The inertia of the bike (tendency to keep moving straight) causes it to pressed hard against the wall, resulting in a large normal contact force. A large normal contact force is crucial because the amount of friction depends on it. It is the frictional force that holds up the weight of the car.