The High Sparrow was defeated by Cersei at the very end of season six. He died with many others in a wildfire explosion.