REGR: fix consolidation/cache issue with take operation
Closes #35521


@jbrockmendel the "short term" fix for 1.1.2
The non-copying alternative would be to not call `self._consolidate_inplace` in `BlockManager.take` LGTM; can look into the no-copy solution longer-term thanks! @MeeseeksDev backport to 1.1.x