No, it doesn't perform a full system reboot. It only restarts the network services to apply the new qdisc rules, which causes a brief 2-3 second drop in connectivity.
However, since I use my custom script to fine-tune the Cake parameters (overhead, pinning, etc.), I always run my command right...