More than half of survey respondents said AI is "over-hyped," even as it's clearly impacted software development.