Americans remain pessimistic on the economy as high prices drive cuts to essentials and nonessential spending. Trump's approval on the economy and inflation remains weak, CNBC's survey found.