I disagree with blanket statements like this. Rainbow color maps aren't ideal for showing relative difference in values. But they are great if you want to be able to tell what the value (range) in a given location is. This is almost impossible with a 10-shade grey-scale legend or a height map.
Disclaimer: I use rainbow color maps all the time because I'm often interested in critical value areas of my plots.