The good-natured state visit demonstrated strong relations, but no ally is likely to change the US president's mind.