How to repair/replace toggle bolt that pulled out of drywall?
See any of the sheetrock/drywall repair questions for how to fix the hole in the sheetrock/drywall. Here's some:

first time drywall repair 

How to fix a large hole in drywall

But you might first want to make a much bigger hole in the sheetrock (no worries, a big big hole is no more trouble to fix than a big small one - in fact the typical method to fix a fairly large small hole in the sheetrock is to cut a square that reaches to the framing on both sides of the hole) and insert some wood framing to take the screw, since you are clearly putting on a lot of force with these "not heavy" drapes and rod, if it keeps ripping out.