Picture the postcard of the beloved golden retriever on the mantelpiece. Standing guard because it is literally standing looking out into the room. The singer's subject is going to stand guard in a similar way - there to be looked at lovingly, apparently standing guard, but absolutely useless in a guard capacity if called upon.