Imagine a simpler case where the is no sideways acceleration.
The container holds water. Without the container exerting forces, the water would accelerate downward. There is another way of thinking about it. You could put a container of water on a rocket in space. The rocket accelerates the container upward. You would not be able to tell the difference in pressure and forces on wooden balls and such.
The ball feels an "upward" force parallel to the rocket force. This originates in pressure differences in layers of water. Deeper layers have more water on them, which press harder than on shallow layers. So water presses harder on the bottom of the ball than on the top.
The surface of the water is perpendicular to the force. If one side of the surface was higher, water could flow downhill.
So the string and surface are perpendicular.
The situation is the same if you add a second engine on the side of the rocket. The total force is at an angle. The string and surface align with the total force.