A new survey finds Americans are optimistic about manufacturing. But with a looming trade war and uncertainty over a new deal with Canada and Mexico, there’s still some concern for the future.