I ran a locked-room murder mystery in my campaign and the bard forgot that she had zone-of-truth for the entire time until the very last moment. So yes, this does happen