The sweet moment took place during the yearly royal outing to Sandringham for a church service