Interesting project....So you are planning to create a living tunnel of trees for curcubits and beans to climb in and up. We've had a bit of discussion about simple
living trellises, but making a tunnel to have an inside, as well as a outside structure gives the idea more functionality and complexity.
As Tereza points out you may have a conflict or compromise depending on the prevailing winds and terrain inclination.
Orienting the tunnel with the main axis North-South will mean that both sides get equal amount of sunlight (morning on one side evening on the other). If your afternoon sun is more intense, you may wish to reduce that exposure slightly by tilting the axis a bit.
Whether you get much of a draft through for ventilation inside the tunnel will depend on your local winds as much as anything. If you are lucky then the winds also go North-South. If not you will have to guess how much to compromise on solar aspect to gain ventilation. Making the trees wider spaced might help ventilate along the length through the sides rather than just through the ends.