A new report finds that a majority of Americans think the U.S. should be a world leader in science, but Democrats increasingly believe other countries are catching up