yes, if we sinned, we should feel like David did after his series of bad decisions..., awful, guilty, low..
there is s difference in being sorry about the consequences of sin, or being sorry you did something you should not have done, or vise versa...