Yup it does include the demo scene. But these are not png files. I'm glad you asked that.
These effects uses the Unity Particle System. So if you're not using the Unity Game Engine I don't recommend buying this.
If you are using Unity, then this package is a dramatically more lightweight, flexible, and efficient than using standard png files for effects.