President Donald Trump is registering the worst economic approval numbers of his presidential career amid broad discontent over his handling of tariffs, inflation and government spending, according to the latest CNBC All-America Economic Survey.