Nah. Players attempt what Rooney did fairly regularly. Its spectacular that it actually worked, but they attempt it comparitively often. What Jerome Simpson did is unheard of, and it actually worked. Simpson's jump > Rooney's goal.
But now it will probably become quite common for people to do it.
What makes rooneys goal amazing was how well he did it. If you watch the tape you'll see that it was just a laser and went straight nine. Which while on the ground is hard enough but upside mid-air? There was nothing the goalie could do about that one.
So front flip touchdown maybe become common and people will no doubt score off of it easily. The bicycle kick while attempted often (i have in several club games and actually made one) is almost never hit well enough to come close to scoring much less with the speed power and accuracy of Rooneys rocket.