New insights into the physics of rotating spokes in partially magnetized E × B plasmas