Why is my half-wave rectifier output in mV when the input is AC 10Hz 100V?
As suggested by @JRE, I simulated it with a different series resistance.


The series resistance limits the voltage, as the resistance of the coil is very small. So you made a voltage divider, where only a small part of the voltage sits across the coil.