Commentators explain that David's 'displeasure' was a complex emotion, a mix of anger, grief, and vexation. His anger was not necessarily directed at God Himself, but at the shocking and disruptive judgment that halted his well-intentioned plans to honor God. It shows a very human struggle to understand a difficult act of God.