Yes, it does get better. But they are all different, and TBH, even once they start sleeping through, there are always some nights when they wake - be it illness, wetting the bed, nightmare or whatever.

DS1 slept through every night from 6 weeks until 7 months. Then we had horror nights until he was 16 months. DS2 started sleeping through at 12 months, and is now the one who is least likely to wake in the night.

So there is definitely light at the end of the tunnel. FWIW, DS1's sleeping was at the shocking stage right up until 3 months before DS2 was born. But luckily he did settle down before the birth.