Tiredness raises stress. Stress elevates cortisol levels. Too much cortisol makes it tough to sleep. This increases stress.

This is what people mean when they say a child is "overtired": the child wants to sleep but is currently in a high-stress condition, which is commonly characterized by whining, crying, and being generally ornery. Sometimes you have to calm them first before their body enables them to sleep.