Questions about modelling a typical crystal radio and simulating in LTspice
No, your source voltage doesn't connect across your tuned circuit.

You need to model the antenna as a short monopole of maybe 0.025 wavelengths. Now it will have a capacitive reactance of about 1000 ohms and the voltage generator will be in series with this impedance back to 0V: -



Picture taken from here.

This voltage source is in series with the capacitor (impedance ~1000 ohms reactive) at your operating frequency. Say you operate at 1 MHz (nominally), 1000 ohms is represented by 159 pF.

You should get good tuning with this but not brilliant because the headphones are still taking energy from the tuned circuit and lowering its Q factor.