Man my Hebrew is rusty, but I think that last says something more literally like “it was a bad word, what David did, in the eyes of the LORD.” (LORD is the tetragrammaton, the special covenant name of God to the Hebrews.)
There are still great leaders out there. Gen. Petraeus was available to do what was required at the time. And now after this, his time has passed. There are new leaders always waiting in the wings. Remember it is the continual consciousness of our western way of life that each American either adds to positively, or negatively, like a floating cloud absorbing our breathe of worth, enhanced or diminished.