I'm not a science expert or anything, but I'd guess that artificial gravity created inside the ship would not be the same as gravity on a planet when a ship turns upside down in space because the ship's gravity field is turning with it therefore applying up and down only inside the ship which would not be applied outside of the ship. Also, as for pilots getting affected by a spinning ship, well they'd be looking out the cockpit and while they wouldn't be thrown all over the place they would still have effects from looking outwards and watching stuff spin around, just like if you spun around in a circle.