[VL] Enhancements to move more on-heap memory allocation to off-heap

### Description

This will be a series of efforts to move more on-heap memory allocation to off-heap against both Spark and Gluten's code, to reduce the risk of JVM heap OOMs, and to allow users to be able to configure a relatively smaller JVM heap size when Gluten is used.

Gluten:

- https://github.com/apache/incubator-gluten/issues/11133

Spark:

Tracked by https://issues.apache.org/jira/browse/SPARK-54089.

### Gluten version

None

The issue provides no files, tests, or entry points. Start by reading Gluten issue #11133 and Spark JIRA SPARK-54089 to identify the scoped allocation work; completion criteria are not defined here.

Written by the indexing model from the issue text.