Snowflake CEO says the biggest misconception about AI is all-or-nothing thinking about its impact. Sridhar Ramaswamy said people either overhype it or brace for doomsday — and the reality is neither.