Let us first recapitulate in which context the cited statement makes sense.
- Let us restrict ourselves to the domain of (decision) functions in $\mathbb{N} \to \{0,1\}$ (a subset of all functions).
- Every such function corresponds to one element of $\mathcal{P}(\mathbb{N})$ (see characteristic function).
- There are countably many Turing machines (simple encoding).
By 1. and 2., there are uncountably many functions. Therefore, there are functions that have no corresponding Turing machine, that is they are not computable. There are simply too many functions; this is what is meant by "there is no surjection".
Now, there are only countably many finite sets in $\mathcal{P}(\mathbb{N})$(extension of Cantor's pairing function). Therefore, the same contradiction can not be derived when only considering finite sets.
If you add some infinite sets to your base set so it becomes uncountable, there is no reason to believe some of the finite sets were undecidable; you only know that there are some undecidable sets. In fact, all finite sets are decidable, so the culprits are always infinite sets.