Why was David's heart afflicted after he had Joab count the men?

David's heart was afflicted because he realized he had acted very foolishly and committed a great sin.