I can prove symbolically that given some random variable $X$ with a strictly increasing continuous CDF, $F$ that $Y = F(X)$ has a Uniform(0,1) distribution:
$$P(Y \leq y) = P(F(X) \leq y) = P(X \leq F^{-1}(y)) = F(F^{-1}(y)) = y$$
But I can't reconcile this with my intuition from looking at the plot of a PDF:
This PDF tells us that values around $x=a$ are less common than values around $x=b$. Values around $x=b$ will also correspond to higher values of the CDF. If we're more likely to plug $x=b$ into $F$ than $x=a$, then shouldn't $Y = F(X)$ not be uniform? Shouldn't $Y$ take on values around $F(b)$ more often than it takes on values around $F(a)$?


From the start, I think you may be mixing up the CDF with the inverse CDF (also called the quantile function).
Suppose $X \sim \mathsf{Beta}(2,1),$ so that the density function is $f_X(x) = 2x,$ for $0 < x < 1$ (and $0$ otherwise). Then the CDF is $F_X(x) = x^2,$ for $0 < x < 1.$
Now let $U \sim \mathsf{UNIF}(0,1)$ and set $U = F_X(X)$ so that $F_X^{-1}(U) = \sqrt{U} = X.$ This result is widely used in simulation to sample realizations of $X.$ If one generates a random sample from $\mathsf{UNIF}(0,1)$ and takes square roots of the values, then one has a random sample from $\mathsf{Beta}(2,1).$
Here are histograms 20,000 realizations of $U \sim \mathsf{Unif}(0,1)$ and corresponding $X = \sqrt{U} \sim \mathsf{Beta}(2,1).$ Colors of objects and images are the same. Each histogram bar represents about 2000 values.