Has Lisp ever really been anything more than an academic language with very little real-life applicability?
Yes.
Common Lisp and a subset of its ancestors are not academic languages at all. A few people even made money with it.
Scheme is (in particular) the academic lisp.
There are some corner markets (like early AI) that favored Lisp or Lisp-like languages, but they are pretty small and don't really have a mountain of legacy Lisp code to maintain.
I think the real reason "early AI" and such used Lisp was because it was a nice-to-use language the way Python/Perl/Ruby later were in comparison to C/C++03/Java. They just didn't have needs such as distributing software on floppies to Windows 3.1 users and running ultra-fast, and when other people ended up not needing the same thing (e.g. server-side environments), the same thing happened. Of course, I wasn't there.
Also, Haskell isn't obsolete in any sense, but C is obsolete for some set of things it used to be a premier choice for.