I empathize with your disappointment. I once persuaded a gallery to exhibit my work, not exclusively, just a corner where my drawings, of interesting faces, people doing interesting things, and some interesting and beautiful species of local moths with a brief description, their range and habits, species names, etc., were available for sale. They liked my stuff, kept it on display for a year. Nothing sold. Eventually they had to reclaim their shelf space and now some of these pieces hang on my walls. I enjoy them, at least.
Sorry, bro.
When they say "Create the work you want to see" as the ultimate form of creativity, the monuments to (commercial) failure hang on our own walls as a reminder of our latent avarice.
Not only only to hope for capital, but the certain greed each and every creative (or at least, me) has to send bucket after bucket into the well, in the hopes that something sublime, something perfect, something ideal will emerge from the watery depths.