Yep, it's the "Spell Effect" sprite that is using all that vram. Without it the vram usage drops down to about 20 mb.
You could delete every other frame of it's animations and reduce the vram usage by half, at the expense of having slightly less smooth animations.
Another solution would be to take the images you imported re-size them by half and re-import them into construct. That would reduce the vram usage to one forth of what it uses now. The quality reduction will not be too noticeable since the animations are of fire and smoke, which are by nature a bit blurry.
If either of those is not enough you could do both and reduce the usage to one eighth of the current.