Tensions likely to persist despite mostly convivial meeting between Canadian prime minister and US president