This is the circuit image is for your plot (also from the link in your question) shown for completion: -

Going back to your bode-type-plot...
I just want to understand what is the blue trace and the red one.
The blue trace is the true magnitude response of the output when the value of the resistor is quite low in value. I can't be numerically precise about this because it depends on the values of L and C. Nevertheless this is called the under-damped case and is typified by the resonant peak that you observe in blue.
The red trace is an approximate "straight-line" version of the bode plot that we sometimes use. These are often referred to as asymptotes and are just an approximation to the real response and don't include the resonant peaks.
I will also add that the graph in your image is for the square of the transfer function and I don't find that this is helpful at all. If you want to play with a real bode-plot then alter the values in the calculator in my basic website: -

The above gives the true response and all the incidental values associated with this type of low-pass filter.
And how to understand the intuitive behaviour of the RLC circuit to understand how the peak appears?
This can take a while to sink in but, a simple way to imagine it is when the value of resistance is very low. So, at resonance the L and C act as a series tuned circuit across the input source and, if R is very small in value there will be a large flow of current (much more than at other parts of the spectrum) and, this generates the large peak in output voltage.