okay...Do you mean to say that the pressure is fixed but the force depends on the container taken?

pressure = force/area

By the time the bucket moves, water has also moved it's direction of force

Let's assume the bottom of the bucket forms the circle in which water rotates. At every point in time the force exerted by water is tangential to the circle and hence perpendicular to the bottom of the bucket

because it isn't my homework and the discussion is more about a concept than the solution of this question in particular

but why does the water want to go through the bucket from its bottom, doesn't it want to go tangentially

As there is normal force pushing water from the bottom of the bucket, there must be a force pushing the water towards the bucket. I don't understand when the tension is inwards and water wants to go tangentially due to inertia then what force is pushing it outwards? considering the observer to be in an inertial frame there is no centrifugal force too...

I don't understand when the tension is inwards and water wants to go tangentially due to inertia then what force is pushing it outwards? considering the observer to be in an inertial frame there is no centrifugal force too...