The duke discussed the 'emotional ups and downs' of parents as he spoke to a room of seriously ill children and their families