I believe it does demmonstrate relative motion because all motion is relative to something. I think in this particular experiment motion is most relative to the earth. It is acting upon cintrificul forces and also being acted upon by inertia. I don't think there is an ultimate frame of reference because it can be looked at from varios perspectives such as the earth's frame of reference or the bucket's.