Difference between Deep Sleep and Nightime sleep?

I'm having a hard time figuring out the difference between deep sleep and nighttime sleep. It looks like both are useful for overnight hours and both try to sleep immediately. In particular I'm confused by the statement on the deep sleep section saying "This is useful for overnight hours when you will not be driving or charging", yet with deep sleep enabled I have not been missing my overnight charges.

Can anyone clarify this?

Also, this knowledge base article does not mention nighttime sleep: https://support.teslafi.com/knowledge-bases/2/articles/640-enabling-sleep-settings-to-limit-vampire-loss