The reason the voltage is rediculously large is that in long-range power transmission, it is more efficient transmit high voltage with low current than a lower voltage with moderate current. A substation uses some big-ass transformers to take this high voltage down to our more familiar 120V AC.
'Substation' is also the name given to small clubs in the San Francisco Bay Area that are spin-offs of The Power Exchange.