Should there be standing water in the drain pipe under my second floor shower?
Yes, it's a trap for your shower, just like you have a trap under your sink. The P trap prevents sewer gases from coming back into the home, which would smell, and possibly cause a methane explosion.