Removing carbon dioxide via your lungs doesn't mean your brain gets more oxygen. The "altered states of consciousness" are symptoms of oxygen deprivation which can be induced in other ways, but maybe hyperventilation is a particularly fun way to do it.