Gary Naylor sees a spectacular and thought-provoking revival of Cavalli's 17th century opera of gods, myths and mortals.