What splicing achieves that connectors cannot
A connector introduces an air gap, or at best a polished physical contact, between two fibre ends, and this junction always adds some optical loss and a potential point of contamination. A splice, by contrast, joins the glass fibres directly, which is why a good splice typically loses far less light than a connector pair.
Splicing is used wherever a continuous run of fibre needs to be longer than what comes on a single reel, wherever a damaged section of cable needs to be cut out and repaired, and wherever a pre-terminated pigtail needs to be joined to field-installed cable rather than terminating a connector directly onto the fibre by hand.