According to the universal approximation theorems mappings that satisfy these criteria are, in principle, learnable.
One should note that these theorems are not constructive, thus provide no algorithm for constructing the model or verifying the conditions. They only state that if the conditions hold, a task is theoretically learnable by some (ANN) architecture.
Linear mappings are also constructively and demonstrably learnable by linear models.
Furthermore, Probably Approximately Correct (PAC) learning theory and VC theory specify conditions under which data can lead to selecting (learning) some function $h^*$ in a set $H$ of possible functions (hypotheses), which most probably fit the data. These approaches attempt to characterize learnability in both statistical and computational terms.
Now, whether a certain task is about a mapping that satisfies these criteria, or is outside the scope of these theoretical results, does not necessarily imply that it is unlearnable, although theoretically it is an open question (eg universal inductive inference theory is uncomputable).
Assuming that a (ML) model for a certain mapping provides a shorter algorithmic description of that mapping than the explicit mapping itself (eg as sequence of input/output pairs), then one way to formalize unlearnability would be to claim that there can be no shorter algorithmic description of the mapping except the possibly infinite explicit mapping itself. In other words, if the mapping is algorithmically random then it is unlearnable. In this respect one can employ concepts, for example, such as Kolmogorov complexity and algorithmic randomness (see, for example, On the impossibility of discovering a formula for primes using AI). There is a (approximate) relation between algorithmic randomness and statistical randomness, as there is a (approximate) relation between algorithmic information and statistical information (eg for large enough sequences). This means that statistical notions of randomness can be used as criteria for (un)learnability similarly to algorithmic randomness criteria.
Still another way to approach unlearnability is as inefficiency in computational complexity terms when any algorithm to learn/approximate a mapping is provably or likely to be superpolynomial/exponential. In this sense a mapping is unlearnable if it is inefficient. As such, the randomness leading to unlearnability is not the algorithmic/statistical randomness, as above, but rather the cryptographic pseudorandomness of pseudorandom generators and one-way functions.
The above analysis is related to the No Free Lunch Theorems (NFL) for optimization and machine learning, in the sense that when a mapping is so random (in some sense of randomness as mentioned above), then this means that there is no structure that can be used and/or learned, thus no algorithm performs any better, on average, than random guessing (NFL theorem). Thus, effectively, the mapping is as unlearnable as it can be since it exhibits the minimum structure possible, and is thus maximally random.