It's give and take, it will help more than bare hard wall.
Heavy curtains are the cheapest/easiest way to "sound deaden" a normal room. Their fabric surface area is greater than the bare wall, and the weight helps isolate vibration.
Thinner ones will be less effective. Never effective as foam, and no method is as effective as actual mechanical isolation (IE a room suspended in a room)