Powerball has captured the imagination of tens of millions with its tantalizing jackpots and thrilling attracts. For many, it's not nearly profitable