The SRF of such a capacitor will be much lower than 1 MHz or even 500 kHz. Here's a sweep of the impedance and ESR of a similar 470 uF aluminum electrolytic. The measurement is made with essentially zero lead length:
View attachment 100316
The SRF is at about 80 kHz. With an additional 1 inch of lead length this is the result:
View attachment 100317
Now the SRF is about 40 kHz.
Also, the ESR is a lot higher than what you're getting with your MLCCs. The rated maximum impedance at 100 kHz for the 470 uF cap in your link is shown as 75 milliohms. The ESR at the SRF shown in the first image I've posted here is about 30 milliohms. And if you look carefully, you can see the slight increase due to the extra 1 inch of lead length in the second image.