Root pressure only provides a moderate push in the overall movement of water or water transport. It does not play a major role in the movement of water up the tall trees. 
The main contribution of the root pressure is to re-establish the continuous flow of water molecules in the xylem which often break under the enormous tensions created by transpiration.