Wave turbulence in rotating and non-rotating magnetohydrodynamics