Let me try to answer.
The meaning of impedance in this case is the same as always! you can see it was the relation between the voltage between the terminals and the current going into your (equivalent) circuit (or two-terminal element). It doesn't really matter of it's complex or not, it just makes things a bit more complicated at first.
The important thing to notice is that, in this case, impedance is dependent on frecuency, which doesn't happen when you have a purely resistive circuit.
As you have correctly guessed the impedance corresponds to 0 or infinity at that particular frecuency and as you know its a continuous function (expect for the point where it goes to infnity) so for frecuencies close to 1000 rad/s, we call this the resonant frecuency of the system, for obvious reasons, it'll be very close to 0 or very large, respectively.
If you add a resistance in series to the circuit, to account for the fact that your components are not perfect capacitors/inductors or for the resistance of the wire itself. You can see that the impedance of the new circuit won't go to zero or infinity but will go to a very low value or to a very high value for that particular frecuency. You have just made a band-pass filter or a band-stop filter!
One typical aplication of this circuit, which you can (and should!) try for yourself is an AM radio. AM stands for amplitude modulation, which means that the message is coded in the amplitude of the wave, which has a constant frecuency, which is perfect for us. If you use the circuit as a band-pass filter (impedance 0) and you feed it with multiple frecuencies waves hooking it to an antenna (radio station waves) the circuit will "select" only the waves which have a frecuency sufficiently close to the resonant frecuency and with very little extra components, in fact you can do this with only a diode on top of the inductor and capacitor (of course you will need some way to listen to it, like a headphone speaker).
Here is the simplified schematic for the AM radio. You can tune the station if you have a varying capacitor or inductor.
View attachment 93363
I hope this helps you at least a bit, I may have divagated a bit, can't help it!