I still remember some of my colleagues scratching their heads to properly design the "backend" to make sure there was only one concurrent connection to Cache, as we only had license for one. This was supposed to be an app used by multiple users.
I don't remember much more details, apart from the fact that it was this job the one that made me decide I didn't want to be a software developer :)
As to why would anyone keep using that DB, I guess the other HNer got it right. Old, ancient code bases that "just work" and no one wants to touch with a barge pole.
Advantages (at the time): freely available, everybody else is using it, easy to learn, interpreted, good performance on resource constrained hardware, multi-process/multi-user support, built in database/persistent storage.