87 As regards the prophetic significance of David's sin, a single word must suffice. The names occurring in the narrative show what it typifies. David means, strong of hand, or desirable; and what can be stronger than the Lion of the tribe of Judah, who has conquered the world, or more desirable than He of whom the prophet says, "The desire of all nations shall come?" Bersabee means, well of satisfaction, or seventh well: either of these interpretations will suit our purpose.
So, in the Song of Songs, the spouse, who is the Church, is called a well of living water; or again, the number seven represents the Holy Spirit, as in the number of days in Pentecost, when the Holy Spirit came from heaven. We learn also from the book of Tobit, that Pentecost was the feast of seven weeks. To forty-nine, which is seven times seven, one is added to denote unity. To this effect is the saying of the apostle: "Bearing with one another in love, endeavoring to keep the unity of the Spirit in the bond of peace." The Church becomes a well of satisfaction by this gift of the Spirit, the number seven denoting its spirituality; for it is in her a fountain of living water springing up unto everlasting life, and he who has it shall never thirst. Uriah, Bersabee's husband, must, from the meaning of his name, be understood as representing the devil.
It is in union to the devil that all are bound whom the grace of God sets free, that the Church without spot or wrinkle may be married to her true Saviour. Uriah means, my light of God; and Hittite means, cut off, referring either to his not abiding in the truth, when he was cut off on account of his pride from the celestial light which he had of God, or to his transforming himself into an angel of light, because after losing his real strength by his fall, he still dares to say, My light is of God.
The literal David, then, was guilty of a heinous crime, which God by the prophet condemned in the rebuke addressed to David, and which David atoned for by his repentance. On the other hand, He who is the desire of all nations loved the Church when washing herself on the roof, that is, when cleansing herself from the pollution of the world, and in spiritual contemplation mounting above her house of clay, and trampling upon it; and after commencing an acquaintance, He puts to death the devil, whom He first entirely removes from her, and joins her to Himself in perpetual union.
While we hate the sin, we must not overlook the prophetical significance; and while we love, as is His due, that David who in His mercy has freed us from the devil, we may also love the David who by the humility of his repentance healed the wound made by his transgression.
Source: Reply to Faustus the Manichaean (New Advent)