Subspace Perspective on Canonical Correlation Analysis: Dimension Reduction and Minimax Rates