chore: refactor MaterializingSortMergeJoinStream into generators and simplify code to be textbook like as possible

chore: refactor MaterializingSortMergeJoinStream into generators and simplify code to be textbook like as possible #31700