S-transform and Hermite transform of Hilbert space-valued stochastic distributions with applications to stochastic differential equations