A famous "psychic" outs himself as a fake, and starts working as a consultant for the California Bureau of Investigation