AFAIK many folks have a dream of getting a book published, not gettting it to be a best seller. (Probably getting a book published means less in the digital age but still a cool thing to have done.)
This only true the first time. The thrill of being a published author wears off quickly when you realize that this doesn't pay the rent. (In my case, the second time 'round I figured out how to get it to pay the rent as well. Believe me, it's very satisfying.)