The red soil-laden lorry crossed the road divider and collided head-on with the cattle-carrying vehicle, the police say