Low-energy excitations and phase transitions in the frustrated two-dimensional XY model