The key limitation for using a constant electric field (i.e. DC acceleration) is that all materials have an intrinsic breakdown electric field where insulators stop being insulators (true even for air and vacuum!). So if you imagine your electric field as coming from a parallel plate capacitor, the insulator separating the voltages on the plates will break down and short circuit the plates. The solution is to make things bigger so that while the voltage is the same, the electric field (i.e. voltage gradient) is lower and you don't have dielectric breakdown.
However, the approach of making things bigger is very inconvenient. For 30 kV electrons, you can do this with a tabletop accelerator as big as a desktop PC. For 300 kV you need several meters of acceleration - still manageable, albeit clunky (c.f. conventional transmission electron microscopes). But if you want teravolts like at the LHC, then you are talking about an accelerator that is roughly as long as the circumference of the earth.
Using an AC approach with RF cavities gets around the dielectric breakdown issue. Now you can use an alternating voltage on a single monolithic piece of metal shaped into a resonant cavity which can sustain an enormous electric field, unlike the metal-insulator-metal stack encountered in something like a DC parallel plate capacitor. The resonant nature of the cavity causes an enhancement of the electric field in certain spatial regions which is approximately given by the quality factor $Q$ of the cavity (typically $10^{10}$ for superconducting cavities). An important upper limit for the E-field arises from AC heating of the RF cavity, which lowers the conductivity and therefore places a limit on the peak field. Using RF cavities also lets you accelerate over a distance that is orders of magnitude smaller than with DC acceleration. Nonetheless, the heating issue among other effects means that RF acceleration still requires a sizeable footprint and "reuse" in a circular geometry.
Because RF cavities are still relatively big, there is a lot of interest in using optical cavity acceleration instead. Since optical light is also an AC electromagnetic wave, the same basic principles should apply as RF cavities, except that optical wavelengths are thousands of times smaller than RF and therefore should enable much, much more compact accelerators. This is still an active area of research, but in principle one could shrink down the entire LHC to fit in a single laboratory room. Howver, there's still a long path of engineering and experimental physics to figure out to using optical cavities to make that happen! Very exciting field to get into the days.
Edit for your addendum: as shown in your image, with DC acceleration you must have all your accelerators in series in increasingly higher voltage. If you just just put a series of plates one after the other as $0$, $+V$, $0$, $+V$,... (i.e. accelerating capacitors arranged in parallel) then you will have that the charged particle accelerates from $0$ to $+V$ and decelerates when it goes from $+V$ to $0$. So there is no escaping having extremely large voltages stacked sequentially (i.e. $0$, $+V$, $+2V$, $+3V$,...). However, with pulsed beams and RF cavities, you can time the RF wave so that the charged particles always sees an E field of the same sign to kick it in the right direction.