Text this: Subspace-based local compilation of variational quantum circuits for large-scale quantum many-body simulation