This is a follow up on Michael Greinecker's answer. I don't see the issue as having to do with uniform partitions at all; there is no requirement in the definition of either integral that anything has to be partitioned uniformly.
The Lebesgue integral of a non-negative measurable function $f$ is defined as the supremum $S_f$ of the "areas" of non-negative "Lebesgue simple" functions that are bounded by $f$ (the supremum may be $\infty$). These functions were defined in Michael Greinecker's post: they are finite linear combinations of characteristic functions of measurable sets. The supremum $S_f$ is well-defined for every non-negative measurable function. The proofs of many convergence theorems come down to showing that other limit operations can be exchanged (commuted) with this supremum operation. Note that the definition of the Lebesgue integral phrased this way is not about partitions at all: it is just about how much area can fit below the graph of a non-negative measurable function.
The extension of the Lebesgue integral to general (not necessarily non-negative) measurable functions is routine, by dividing the function into positive and negative parts that are handled independently.
On the other hand, the Riemann integral is defined in a much more restrictive way. In order determine whether a Riemann integral of a non-negative measurable function $f$ exists, it is not enough to look at the integrals of nonnegative "Riemann simple" functions that are bounded by $f$. These functions are finite linear combinations of characteristic functions of intervals, as Michael Greinecker says. For example, this supremum is perfectly well defined for $f = 1_\mathbb{Q}$, and equal to 0, because every non-negative constant function on an interval that is bounded below $1_\mathbb{Q}$ must be identically zero on that interval. But $1_\mathbb{Q}$ is a famous example of a function that is not Riemann integrable. The problem, of course, is that the definition of the Riemann integral requires more than just the convergence of that supremum.
Thus proving that a non-negative function is Riemann integrable requires more than showing that a particular supremum exists, and this causes corresponding problems in proving limit theorems for Riemann integration. On the other hand, the Lebesgue integral exists for every measurable non-negative function (it may be $\infty$), so this problem simply doesn't exist in the setting of Lebesgue integration. There is an extra step in proving a limit theorem for Riemann integration, and sometimes this step is insurmountable.
There is a theorem that a bounded function on a closed bounded interval is Riemann integrable if and only if it is Lebesgue integrable and is continuous almost everywhere on the interval. This shows, in hindsight, an intuition for why limit theorems must fail in the Riemann case: because "continuity almost everywhere" is not preserved by the sorts of limit operations that are considered in these theorems. For example, $1_\mathbb{Q}$ is a pointwise limit of an increasing sequence of functions $(f_i)$ each of which is continuous almost everywhere, as described by Michael Greinecker. Since pointwise limits don't respect "almost everywhere continuity", it will not be possible to show that Riemann integration acts well with respect to these limits. In the non-negative case, Lebesgue integration only requires that the limit function has to be measurable, and measurability is preserved under the sorts of limits that are considered.
P.S. The use of the extended real line $[-\infty,\infty]$ in the Lebesgue setting, but not typically in the Riemann setting, is another minor cause of difficulty in the Riemann setting. And, as usual, there can be confusion because in the Lebesgue sense "integrable" means "has a finite integral" rather than "the Lebesgue integral exists". Neither of these gets to the heart of the matter, which is that every non-negative measurable function has an integral in the Lebesgue sense, but this fails in the Riemann sense.