Text this: Refining resource estimation for the quantum computation of vibrational molecular spectra through Trotter error analysis