Once a prominent bear, Wilson now predicts modest gains for the S&P 500, citing improved earnings growth and economic outlook.