"The writing is on the wall" is an expression which means that EVERYONE knows something has or is about to happen.  This song, although it sounds like it's fun, is actually about a couple that is about to break up!  The singer is just hoping for one more good moment together...