This is one of my favorite verses. I don't have a lot of enemies that are literally trying to kill me like David did, but I think we all have a lot of sins we could call enemies and of course there is the enemy himself and his workers.
The verse reminds me to look at God's righteousness and not my own or my own idea of what it should be, and also reminds me to pray that I might walk on the right path.
My e-sword commentary from Clarke has this:
Lead me, O Lord, in thy righteousness - When entered into the house, and prostrated before the temple, he knew that, unless God continued to lead and direct, he was not likely to profit even by such great advantages. We need God not only to bring us to his house, but to keep our feet while we are there.
Because of mine enemies - His conduct was marked; his enemies looked upon and watched him with an evil eye. They would have been glad of his halting, that they might have brought a reproach on the good cause which he had espoused. O how cautiously should those walk who make a profession of living to God, of knowing themselves to be in his favor, and of being delivered from all sin in this life!
Make thy way straight - Show me that I must go right on; and let thy light always shine on my path, that I may see how to proceed.