@Mark There is a nice graphical interpretation of the discriminant. Let us consider
$$x^3+px+q=0$$
as the equation giving the abscissas of intersection point(s) of
$$\begin{cases}y=x^3 \ \ & \text{cubic curve (C)}\\y=-px-q \ \ & \text{straight line } \ (D_{p,q})\end{cases}$$
(see graphics below) According to the values of $p$ and $q$, $(C) \cap (D_{p,q})$ have one, two or three intersection points (which correspond to one, two or three real roots).
For example the green line has one intersection point with (C), whereas the blue line has three. The transition case between 1 root ans three roots is when there is a double root; this means exactly for $(D_{p,q})$ that it must be tangent to $(C)$, as are all the black lines represented on the figure below.
Writing the general equation of the tangent to (C) under the form:
$$y=x_0^3+3x_0^2(x-x_0) \ \ \iff \ \ y=(3x_0^2)x+(-2x_0^3)$$
By identification with the generic equation $y=-px-q$ of $(D_{p,q})$, we obtain
$$\begin{cases}\ \ \ 3x_0^2&=&-p\\-2x_0^3&=&-q\end{cases}$$
Eliminating $x_0$ between these two equations give the equation $4p^3+27q^2=0$, which is a condition of transition between the case "one real solution" and 3 "real solutions" (with a complete analogy with the rôle of condition $\Delta=0$ for a quadratic).