fix: repair AQE plan rewrites, remove a redundant shuffle, and enable adaptive query planning by default

fix: repair AQE plan rewrites, remove a redundant shuffle, and enable adaptive query planning by default #6184