Collective modes and the effect of single-particle excitations in the BCS-BEC crossover region of a trapped Fermi superfluid