I am experiencing the same issue.
Since the latest update, Sims on a lot freeze in place and do not move at all. This happens not only to the household Sims but also to bartenders and townies who appear after traveling to a lot.
Tasks keep piling up without being executed, and occasionally when they do move, they start dancing instead.
If I reset the object, I can make them walk to a location, but they remain frozen when trying to perform actions such as throwing away trash, eating meals, or caring for infants.
Autonomous actions still trigger, such as cleaning, grilling food, or diving into a dumpster to search for food, but these animations occur far away from the actual target object.
Another example: when an infant reached the “standing up” milestone, all the adults gathered around and froze, while the infant kept glowing for hours. After resetting the actions, the standing-up animation resumed, but the chair the infant was trying to use was located far away, and the infant’s arms stretched unnaturally in one direction.
I also tested by removing all mods, but the issue still persists. I am playing on PC.