Plenty of people think that functional languages are useful
for real world tasks. Here's another link for example:
Functional Programming in the Real World (a particular
example that is often cited is
Erlang, used in
soft real-time telecommunications applications).
For one liberal enough to consider Lisp a functional language,
consider also
this
list of Lisp users.