The sim is manipulating the throttle when you pitch down or up. IRL, nose up will cause the quad to move backwards. If you increase throttle, you will climb while moving backwards. If you are holding a hover and bring the nose up without increasing the throttle, the drone will decrease altitude...