[Doc]add more description in kafka connector and modify the name for op field (backport #43074)

[Doc]add more description in kafka connector and modify the name for op field (backport #43074) #6434