If your cats stick on the carpet, I'd suggest getting another type of carpet (or cat). Personally, I do not have experience with cat sand. However, I would only vacuum it, not with the mop function.
regarding hair on the carpet - yes, that is a weak point of vacuum roboters. IMHO it shouldn't be seen as a replacement of "traditional" vacuuming, but rather an addition.