No, Carl Bernstein did not serve as a spy. He is a journalist who is best known for his work with Bob Woodward on the Watergate scandal. He has won numerous awards for his journalism, including two Pulitzer Prizes.
Eduard Bernstein: The Trailblazer of Social Democracy