If someone said, it is a freaking weekend..what does he means?
It's being used as a replacment for the word f***ing.
Why he needs to emphasize that it's the weekend, I cannot tell you.
I'm not a teacher, but I write for a living. Please don't ask me about 2nd conditionals, but I'm a safe bet for what reads well in (American) English.