Ahead of visit by US president, surveys find public also almost universally pessimistic about the possibility of a breakthrough with the Palestinians