Most Americans now express opposition to Trump's tariffs and little confidence in his economic leadership, a shift since the election.