Senate majority leader, who was one of four Democrats to vote against 2015 pact, makes first public comments on matter since coming out against Trump's 2018 withdrawal