The US leader added that "it's going to be a big, beautiful agreement, and everyone's going to be thrilled"