A core needle biopsy is generally a painless procedure because local anesthesia is applied to the area where the intervention will be performed. Patients may experience slight pressure or discomfort during the procedure.