President’s political standing is worsening, driven by views of his handling of the economy and tariffs