Paintings from 1750 on didn’t show ‘Christian’ sibyls, but returned to their classical meaning. Then came Turner’s marvellous narrative landscapes.