Using Do Not Disturb Mode on your watch during your sleeping hours should stop the watch face from lighting up when you rotate your wrist. If a button is selected, however, this will illuminate the watch face.
You could also disable Gesture all together but this would also impact your watch outside of your sleeping hours and may not be ideal. To customize the gesture settings see: Customizing the Display Settings.
