The CNBC All-America Economic Survey found 43 percent of the public believes the economy is excellent or good.