In this video you can see that cats can use their tail as a gyroscope to orient themselves while in free fall without any form of propulsion, so it’s more of an active manoeuvering system than just ballast.

youtu.be/WzJGvAIk2VQ