It's been my main source of income for 2 years, my seats are $39, about double the average SPG cost.
I do still run and play TTRPGs with friends- the biggest impact that running games has had is that most of my nights are unavailable, since I run 3-5 nights/week and Sunday mornings.
Like I said earlier, the nice thing is that because I primarily run D&D, and some of my old friend-players are now a couple of my paying-players, everyone's pretty cool playing NOT D&D. Whether I'm running, or someone else is, we do some kind of ttrpg like DCC or OSE or WHF- or occasionally we do a paint night for minis etc.
For me I think that musician analogy you gave is pretty accurate- I'd be happy to run something off the cuff, not serious for friends; but the heavy mental load stuff that year(s)-long campaigns require, that's not something I'm eager to add to my plate now that I run multiple campaigns every week for a living.
I can't speak for others obviously
