Following a moral failure, a deep fear sets in—not just of punishment, but of spiritual disconnection and the loss of closeness to God. The desperate plea made here is not a request to reach new heights, but rather a cry to hold onto the spiritual standing that already exists and to avoid being pushed away by the Creator [ביאור שטיינזלץ]. There is a terrifying thought that God might now view him as despised or unwanted. To counter this, he begs God to continue looking upon him with mercy and love rather than turning away [רד״ק].
Being pushed away by God carries consequences far beyond a feeling of personal rejection. It means being abandoned to the random events of the world and the harshness of time, entirely losing God's protective, personal care [מצודת דוד, מלבי״ם]. Furthermore, there is a dread of a deep, permanent spiritual decline. Before the failure, he walked at an elevated, independent level closely connected to God, much like the founding fathers of the nation. Now, carrying the weight of his actions, he fears his spiritual essence has been damaged and he will be cast down from that high standing [אלשיך].
The prayer then turns inward, focusing on internal holiness [ביאור שטיינזלץ]. The primary approach among commentators is that the holy spirit had always rested upon him, granting him the prophetic vision needed to compose sacred songs. However, the heavy sorrow and guilt brought on by the sin caused him to feel this prophetic spirit slipping away. He pleads that it not be removed permanently, but that it will eventually return [רד״ק, מאירי]. This holy spirit is essential, as it guides a person along the path of truth and helps them achieve inner perfection [מלבי״ם]. Yet, in order for this divine presence to remain, a person must first actively prepare themselves by creating a pure heart and a proper mindset [אלשיך].
Ultimately, this deep anxiety about losing his spiritual greatness finds a comforting resolution. Toward the end of his life, he was able to testify that the spirit of God indeed spoke through him. This serves as lasting proof that his heartfelt prayer was accepted, and the divine spirit was never permanently taken away [אבן עזרא].