On M:S, as you reach orbit you have several moments of simulated zero G. The effect is created by a freefall. I'm not sure of the actual mechanism, but the ride capsule is dropped, obviously in a controlled manner, creating the illusion of zero G.
This is actually an accurate representation, because true zero G is not achieved by orbiting space craft. The craft is in a state of constant freefall. Even on the shuttle zero G is an illusion created by the craft hurtling towards the Earth. The craft is placed at an angle that it constantly falls, but never hits the Earth. This is the way over simplified version.
But back to my original point, I really enjoy the zero G, or constant freefall effect, on M:S.
I know exactly the point you are talking about, and I still don't believe you are at zero G. I think the combination of the stopping of spinning of the ride vehilce, coupled with tilting the whole thing forward, makes you think you are at zero G, but you aren't.
And I don't believe the ride is tall enough to create zero g using freefall for any reasonable amount of time. It would only be for fractions of a second. Think about the tower of terror, you are in free fall in that ride (actually i think you are at negative g's) for just a few moments at a time, and look how high that ride has to be for that.
If you truly were at zero g in the ride, then you shoud be able to hold a baseball right in front of you, let it go, and it would stay right there. I'm willing to bet that wouldn't happen.
By tilting the ride forward (my guess as to how they do it), then you feel less pull straight down, but you feel more pressure on the shoulder restraint.