Manchester United's interim head coach Ruud van Nistelrooy has admitted he has "mixed emotions" ahead of his first game in charge of the club after the sacking of Erik ten Hag.