Why do we want another David? He was a failure

Some Christians defend a certain politician by saying “King David was a sinner, too!” But David's sins had disastrous consequences not just for him, but for his nation. We shouldn't want another David, and we don't need another David.