It does nominally bring expertise yes but the primary benefit is ass covering and sounding board. If you're an exec that needs to implement something new & complicated you can either wing it and then the blame is on you if it goes wrong. Or you can bring in consultants and lean on their advice. That gives you someone to blame. And the consultants happily absorb said blame cause they're getting paid either way.
And finally - cross pollination. If you ask them how to do XYZ there is a good chance that the answer is at least in part inspired what they saw at other places/competitors.