[Core] With AQE disable, join tables reordering works wrong

### Backend

CH (ClickHouse)

### Bug description

[Expected behavior] and [actual behavior].

We have a sql as following
```sql
select t1 left join t2 on t1.a = t2.a
```
`t2` only contains less then 100 rows, the final plan uses `t1` as the build side table. It causes OOM

### Spark version

None

### Spark configurations

_No response_

### System information

_No response_

### Relevant logs

_No response_