Do I have to turn off the sleep mode when I get out of bed?

Only when you wake up in the morning and are getting out of bed for the day.

If you wake up in the middle of the night and get out of bed you don't have to turn off sleep mode as the watch will automatically account for this.