If the solder mask expansion were 0, in theory — assuming everything aligned perfectly — the board would work fine. In practice, things never align perfectly.
Too small expansion: The actual hole punched in the solder mask may be slightly less than what you specified (“shrinkage”), and that hole is always be placed in a slightly different location than what you specified (“movement”). If your solder mask expansion is too small, then these misalignments cause the solder mask to partially or completely overlap SMT pads and through-hole pads.
Too big expansion: If the solder mask completely covers most or all of the pad, the SMT part will be completely disconnected from that pad. Then the board will immediately fail the end-of-line go-nogo test.
Many people specifically design the pads of a footprint to comply with IPC’s fillet recommendations. If the solder mask even partially covers some of that pad, then the fillet of solder will be smaller than a person looking only at the copper might expect. If the fillet of solder is too small, then the (SMT or through-hole) part will not be mechanically attached as well. After a few thousand cycles of vibration, the solder may eventually crack, and the part will be completely disconnected from that pad or hole. Then your customer will notice the problem. (This is much worse than a board failing the end-of-line go-nogo test).
Read More: Mastering Selective Soldering: A Comprehensive Guide
#PCB Design
