You are correct in thinking that the null hypothesis of (Complete Spatial) Randomness is rarely of much scientific interest, in any direct sense. CSR usually functions only as a benchmark against which to measure the behaviour of the point process under study.
As with any statistical procedure, point pattern analysis serves to provide insight into the natural mechanism generating the observed data. It may help to anwer questions about this mechanism or to suggest precisely focussed questions that should be asked. What these questions might be depends upon the particular area of application. Likewise how such analysis adds to the understanding of the data depends upon the area of application. What do you want to know about the underlying mechanism? What do you want the data to tell you? What conjectures are you interested in verifying or falsifying?
Point pattern analysis will add to your understanding of a data set only if you have some interest in the data set and care about the information that might be contained in that data set.
Read "Spatial Point Patterns: Methodology and Applications with R" by Baddeley, Rubak and Turner (see http://spatstat.github.io) for many examples of ways in which point patterns may be fruitfully analysed.