lisp is good for making extremely powerful abstractions. these abstractions are good in big programs. The world is moving away from big programs, to small services that talk to each other over the network. lisp has no real differential for these types of programs, and has no good interface to the operating system.
ideally we would be using some form of scheme in the browser, which can be optimized much further than javascript, and transformed into any sort of mini-language that you want. Something OO for games or spreadsheet apps, something functional for a reactive interface, some logic programming for the model layer. Alas this is not the case, so the last place you see programmers using lisp is scripting their editor, or with the jvm. when hadoop and emacs get replaced, you will probably never see it at all.