Impact of magnetic field and rotation on the stochastic excitation of acoustic modes