It's a tradeoff between degrees of control. KinematicBody is easier to control, while RigidBody participates in the built-in physics but is much harder to control accurately.
If you want more control, use KinematicBody. If you don't need much control, and want Godot's physics capabilities, use RigidBody.