Well I wouldn't volenteer to get shot with one, etc . And given a binary choice better than harsh words or a derringer. Arguably better than a knife or a big stick.
In addition to the issues of the cal itself , most (by production numbers) were unreliable junk. When someone went into a gunstore , and wanted a gun, any gun, whichever was cheapest , it was a .25 for decades.
Yes, throughout history there has been a legitamite need for a dependable reliable pistol that is really, really small to the carried in very unconventional manner (ie inside a pair of speedo's , inside a cigarette pack). The percentage of people who really needed one was a very small percentage of those who thought they did, but not quite zero.
I briefly carried one as a BUG. Shooting it convinced me to skip lunch until I saved enough for a then state of the art subcompact .380 .
The week that a subcompact .32acp that cost less than a Seecamp came on the market, all .25acp's became funtionally obsolete.