Yes, we are vaguely aware of the preexistent scholar of pscyhology, Mary Whiton Calkins, who wrote a variety of books on topics of psychology and died in 1930. So it is possible to do quite well in that field, if that is what interests you, although me it does not. The surname is not synonymous with sociology or success, however. Some people just get very lucky in their field due to a variety of factors, the name being only one of these many factors.