When David asks God to "hide thy face from my sins," he is not asking God to withdraw His presence. Commentators clarify this is a specific plea for God to turn His angry, judicial gaze away from David's transgressions. As one scholar puts it, the prayer is, "Do not hide your face from me, but hide it from my sins." It's a request for God to choose not to see the sin, effectively pardoning it.