Does this provide night time privacy even if the lights are on?

There is a possibility you will be able to see some shadowing, but otherwise visibility is blocked. This material blocks about 65% of visible light, in turn also blocking visibility.