A woman's worst fear is sex with the lights on.
Don't assume a woman is self-conscious or insecure about her body. Not all of us are obsessed with being emaciated magazine models, or conversely, in pursuit of surgically inflating our breasts. We love our bodies just as they are and have no qualms about sharing every single curve with you in broad daylight.
So, no, we don't want you to turn off the lights. And no, we aren't insecure about doing it doggy style. It's exciting for us to watch you admire every inch.