Write to reflect, write to encourage, or write to inspire—all of which give us writers a purpose to keep at out craft.
You said it best, we might not make a single cent from our creations, but the smiles and sparks of inspiration we create from our words is what makes writing worth it in the end.
Appreciate your insight on this :)