If I'm not wrong, a moving wall on fluent is a wall with a finite velocity value. The domain is static as well as its boundaries, but there are a value of velocity - the cavity driven flow is a classical example.
A moving frame is a coord system that moves during simulation, e g. rotation. Instead to put all mesh and paddles to rotates, the coord system can do it. Of course in the stationary frame forces will arises due this as Coriolis effect and centripetal acceleration.
Mesh motion is more general and can deal with rotation, shape changes, normal dis placements of wall that changes de domain's volume, e.g. gear pumps, car engines cylinders.
Some times one problem can be simulated by means any of these approaches, and in other cases there only is one possibility. It will dependes on the problem and the numerical protocol.