Exodus 10:18 And he went out from Pharaoh, and intreated the Lord. 19 And the Lord turned a mighty strong west wind, which took away the locusts, and cast them into the Red sea; there remained not one locust in all the coasts of Egypt.
Thus, God who is true to His word, accepted David’s confession, just as God would have done with all of those persons who were participants either directly or indirectly. The problem is that most of them saw nothing wrong with what David did, and as such, it was not necessary to confess or repent of anything as far as they were concerned.
[Patriarchs & Prophets pp 747] The numbering was not finished when David was convicted of his sin. Self-condemned, he “said unto God, I have sinned greatly, because I have done this thing: but now, I beseech Thee, do away the iniquity of Thy servant; for I have done very foolishly.”
The prosperity of Israel under David had been due to the blessing of God rather than to the ability of her king or the strength of her armies. The taking of the census had caused disaffection among the people, yet they had themselves cherished the same sins that prompted David's action.
1st Chronicles 21:8 And David said unto God, I have sinned greatly, because I have done this thing: but now, I beseech thee, do away the iniquity of thy servant; for I have done very foolishly.
May God add His blessing to the study of His word. “Good night” and God bless!