It is possible to calculate the resultant of two polynomials via an algorithm very similar to the Euclidean algorithm for calculating the gcd of polynomials. In this case, applying that algorithm gives:
\begin{align*}
\operatorname{Discr}(X^5 + pX^2 + q) & =
\operatorname{Res}(X^5 + pX^2 + q, 5 X^4 + 2pX)
\\ & =
5^5 \operatorname{Res}(X^5 + pX^2 + q, X^4 + \frac{2p}{5} X) \\
& = 5^5 \operatorname{Res}(X^5 + pX^2 + q - X(X^4 + \frac{2p}{5}X), X^4 + \frac{2p}{5}X) \\
& = 5^5 \operatorname{Res}(\frac{3p}{5} X^2 + q, X^4 + \frac{2p}{5}X) \\
& = 5^5 \operatorname{Res}(X^4 + \frac{2p}{5}X, \frac{3p}{5} X^2 + q) \\
& = 5^5 (3p/5)^4 \operatorname{Res}(X^4 + \frac{2p}{5}X, X^2 + \frac{5q}{3p}) \\
& = 5 \cdot 3^4 p^4 \operatorname{Res}(X^4 + \frac{2p}{5} X - \left(X^2 - \frac{5q}{3p}\right) \left(X^2 + \frac{5q}{3p}\right), X^2 + \frac{5q}{3p}) \\
& = 5 \cdot 3^4 p^4 \operatorname{Res}(\frac{2p}{5} X + \frac{25q^2}{9p^2}, X^2 + \frac{5q}{3p}) \\
& = 5 \cdot 3^4 p^4 (2p/5)^2 \operatorname{Res}(X + \frac{125q^2}{18p^3}, X^2 + \frac{5q}{3p}) \\
& = \frac{2^2 3^4 p^6}{5} \left[\left(\frac{125q^2}{18p^3}\right)^2 + \frac{5q}{3p}\right] = q(108p^5+3125q^3).
\end{align*}
(Here we do the calculation in $\mathbb{Q}(p,q)[X]$, which by functoriality of the resultant must give the same result as the resultant in $\mathbb{Z}[p,q][X]$, and again by functoriality evaluating that polynomial must give the correct answer for the resultant over $\mathbb{Z}[X]$ or $\mathbb{Q}[X]$ for any particular values of $p$ and $q$. In particular, this explains why we get a correct answer even in the case $p=0$.)
(Also note that in a hand calculation, it would be reasonable to stop already at the sixth line, and calculate the resultant as $5\cdot 3^4 p^4 g((-5q/3p)^{1/2}) g(-(-5q/3p)^{1/2})$ where $g(X) = X^4 + \frac{2p}{5}X$ and $\pm(-5q/3p)^{1/2}$ are the roots of $X^2 + \frac{5q}{3p}$ -- where $g(X_0) g(-X_0) = X_0^8 - \frac{4p^2}{25} X_0^2$. On the other hand, an automated calculation could very well continue from the second-to-last line and essentially perform synthetic division of the quadratic polynomial by the linear polynomial.)