Pion wave functions from holographic QCD and the role of infrared renormalons in photon-photon collisions