I don't think Green Lantern will retain the title of DC's most mocked character quite as long as Aquaman did, but he's certainly the easiest punching bag for people to go to right now. However, every character is one good or bad movie or TV show away from being either the coolest or lamest superhero in the world.
The Adam West Batman show went from being the hippest show on the air, to an embarrassment, to a cherished pop cultural icon over the course of its existence. Sooner or later, Ryan Reynolds is going to get tired of poking fun of himself (even though he was, by far, one of the least terrible things about that GL movie), and pop culture will move on to some other superhero to laugh at (while simultaneously flocking to see other superhero movies featuring characters that have been just as lame).