I would suggest that "why we photograph" and "what we want from photography" are not the same and that further, a study of what we want from our photography and an analysis of other peoples goals and how practical ours are given our circumstances could be very useful.
A good answer to why we photograph might be one of the following:
a) a burning need to create
b) I like messing with cameras
or more likely a bit of both, in varying ratios to suit our personalities.
An honest look at what we want from photography might include any of the following:
1) to be recognized as a craftsman or artist, anyway a skilled photographer
2) money - money to justify expensive equipment (see above - playing with toys) or to actually supplement income (in which case forget the expensive toys).
3) to have some nice photographs, to look at
4) to improve our skills, at whatever level me might be now
5) fame - which isn't necessarily the same as recognition
6) to make some really great images, whether anyone else sees them or not.
And I dare say you can add your own suggested goals either observed or experienced.
I have a portfolio case of matted silver prints, probably about 35 of them, representing some of the best work I did BD (before digital). I doubt more than a dozen people in the world have ever seen them (except one workshop). The portfolio rarely sees the light of day, even to me. I suspect that a lot of photographers were the same before digital and the internet.
This can tell us quite a lot about both drive to photograph and goals achieved. There were a lot of happy photographers before the internet, who like me seemed to get satisfaction from photography without fame, money, recognition or even the social aspects of photography. While it is tempting to suggest that nowadays the main goals are fame and fortune, in fact I suspect that the vast majority of photographers might dream of same, but realistically aim for different, more realistic goals. It's a bit like being 58 and pot bellied (not to mention any names, but there's a mirror in our hall) and wishing you had some gorgeous model, star, stud or being of ultimate desire to your taste) at your beck and call. You know damn well you're lucky to have the aging spouse you have, and if you were honest with yourself, having to keep pace with someone like the above dream would be far more trouble than 99% of us would be willing to put out.
Fame and fortune in photography are no different - they are high maintenance, demanding, rude, all consuming and downright fickle. Most of us aren't willing to put up with high and mighty gallery owners, pushy clients, deadlines, marketing, more time spent matting and framing (because we can't make a profit if we get someone else to do it) than we do photographing. We become experts at packaging and mailing rather than composing.
Most of us have jobs which provide a steady income, and which in fact allow us to buy the lovely tools we use). We have houses that need maintained, families who need attention, and probably a life style which we aren't willing to sacrifice to achieve either fame or fortune.
It's a miracle of no small proportion that I, a busy family doctor; have had as much recognition as I have. Largely it's been luck, a certain amount of nerve to put myself forth to be judged, and no small coincidence that I happen to be able to write (even if I can't spell) and to explain things fairly clearly.
The vast majority of photographers are satisfied to produce some nice images, and if every so often someone else gets to appreciate them, so much the better.
A more realistic set of wants might be the following:
i) to always be improving
ii) to have some sense of this progress and where we are. It's not so much the recognition we desire as the assurance that we are doing good work, and how else do we achieve this other than to ask someone else for their opinion?
iii) to create a select few images images which in some small way add to the medium