[memo] reorder should add new plans to intermediate expr join child

[max-hoffman]

There was a bug where we'd add reordered join plans to project or distinct nodes, rather than their join children. Code comment explains more clearly how this works.