The Short Version
The central distinction is broadly correct: piezoelectric autofocus motors are commonly able to hold position with power removed, while conventional VCM autofocus modules usually need current to hold away from their rest position. The caveat is that this contrast is not universal, because specialized VCM autofocus designs have been engineered for zero holding current.