Your load resistance is only 6 ohms so it is almost a dead short. It will have a peaked voltage at the resonant frequency only if the source has an extremely low output impedance (0.06 ohms or less) and if the resistance of the coil is extremely low.
But the output impedance of most signal generators is 50 ohms and a coil might have a resistance that is much higher than the dead short of your load.
But the output impedance of most signal generators is 50 ohms and a coil might have a resistance that is much higher than the dead short of your load.