About half of the 30 or so bands I have played with have been abandoned after a couple of gigs, or non at all.
Mostly I've only just played music for fun. It's much more fun (and certainly easier) playing at some friend's house every week for 18 months than it is to book performances, market the band, produce works for the public, etc.
I have a sticker on my truck that says "This Sticker Will Last Longer Than Your Band", and that's been true.
I don't regret learning to play the entirety of Dark Side of the Moon and performing it once. I know so much Grateful Dead. I've play dozens and dozens of original songs written by friends that won't ever get any attention outside of the 20 people who were paying attention at some bar.
I've also played with more commercially focused endeavors and have an idea of the horrors of trying to tour and manage the commercial aspects of music. It's not like most of these bands were any worse or could not have been marketed.
I've played with a lot of folks who have only ever been in one or two bands.
The thing I find interesting about all that is this point:
they usually vastly underestimate how much work it takes to market a band
and at the same time (I find this a little beautiful) they vastly underestimate the goodness of their own musical output.
Just because projects don't succeed commercially does not mean they aren't well made or that these projects are not worth doing in as things in themselves.