KinematicBodies aren't simulated by physics, so they won't have an automatic response. You basically control them yourself with your own code. They can create collision events, for example, you can test if they are touching the floor or colliding with different objects, but they won't move things by themselves.
For games like Celeste, I doubt they used a physics engine for things like moving platforms or falling tiles. Most likely they coded their own collision for that. As an example, you can test if the player it on top of a platform (maybe by putting a small area collider along the top of the platform) and then moving the player by the same amount the platform is moving. This is tricky to get right, but totally doable.