Vibrational Excitation Mechanism in Tunneling Spectroscopy beyond the Franck-Condon Model