Collective coordinates for nuclear spectral densities in energy transfer and femtosecond spectroscopy of molecular aggregates