Do singular probability distributions have any real-world applications, or are they just a pure-mathematical curiosity? I can't imagine a real quantity that they would describe. But on the other hand, singular functions do have surprising applications, e.g. regarding the fractional quantum Hall effect in condensed-matter physics, so maybe singular probability distributions do as well.
By "real-world application" I don't mean a real phenomenon which could in principle be modeled by a singular distribution, but rather a situation in which engineers, scientists, financial analysts, or other non-mathematicians actually do use them in the context of a commercial application or other non-mathematical "product".
For example, consider an infinite sequence of fair coin-flips, corresponding to iid Bernoulli-$1/2$ random variables $X_n$. Then $2 \sum_{n=1}^\infty 3^{-n} X_n$ has a singular distribution whose cdf is the "devil's staircase".
EDIT: If you want to make it seem more "real-world", you might rephrase this in terms of return on investments or something similar. The point is that a rapidly converging sum of discrete random variables is quite likely to have a singular distribution.