If I ran this site a lot of these spells would be gone, but I don't run this site, Pet runs this site and these spells are here to stay. There's a number of reasons why but the big one is these spells bring people to this site. This site also claims it's entertainment only so get use to the spells.
Also, not every spell in the fantasy section is fake, 99% are fake, but some spells are 'faerie blessing' and 'Dragon wealth'. These spells are cast by those who believe in and work with these creatures, and so they call on their energy to aid them in spellwork much like one would call on a deity. There are limitations [you can't call on a vampire to make you one] but there are a handful of working spells in this section. Just as there are non working spells in the other sections.