New vanishing theorems for mixed Hodge modules and applications