Gamerbytes has published a nice table of XNA games sales and profits, showing fairly ably that you're not going to get rich from the platform any time soon. Put it this way - you'd be lucky to take home $1,000.
The figures show how many times games were trialled, how many times they were bought and how the money's split up.
Fill your boots. Thanks, Kotaku.