David didn't make a mistake. David sinned. At least one person died because of his sin. The sins of church leaders can be very damaging to the church but they shouldn't impact the faith of a mature Christian.