Nicole Kidman looked 'completely attached' to husband Keith Urban during their last red carpet appearance in May