I think the sensation of... OH MY GOODNESS... CAN YOU BELIEVE IT would last depending on the person and the career.
A famous and pious TV Evangelist like Joel Osteen would last longer than someone like Bob Dole or Janet Reno.
Plus, if you don't make a big deal out of it, some of the "Tabloid" fun goes away.
"Who me? Oh I love being tickled. I like to tickle too. Hey, you're a cute reporter. Say Uncle!" LOL...
I have a plan B already in place. Of course, I'm not a celebrity yet.