For the sorrow that is according to the will of God produces a repentance without regret, leading to salvation, but the sorrow of the world produces death. 2 Corinthians 7:10 (NASB)
Sorrow is inevitable in this world, we experience it in our lives from time to time in various degrees. The sorrow of your favourite team losing a match is vastly different to that of the death of a loved one.
In history there have been vast outpourings of public sorrow for the death of prominent people. I remember 16th August 1977, that was the day that Elvis Presley died. It was my first experience of seeing a worldwide outpouring of grief unfolding in the media. I saw the same thing twenty years later on 31st August 1997 when Princess Diana died. Even though the second one did affect me more as an adult, I was also more aware of the uncontrolled public emotion at work. These events as tragic as they were, their sorrow was like a wave on the ocean. It was there briefly and then gone.
In contrast Godly sorrow has a distinct purpose, producing a lasting result. Such sorrow is the result of our conscience being awoken to the presence of sin in our life, and how repugnant that sin is to Almighty God. A realisation of how filthy sin makes our soul fills us with shame and deep sorrow at separation from God. How could we come before a Holy God in such a state?
Dear reader, Jesus Christ wiped away our sin and offers us new pristine garments. We just need to repent of our filthiness (sins) and accept His Gift. Through Him we are saved and ready for Heaven. This is the end result of our sorrow over sin before a Holy God, the joy of eternal salvation.