Is this sentence correct?

The show is great but it is much less than expected.

Not quite. Try this:

The show is great, but not quite as good as I expected.

Yes, the sentence is grammatically correct. It conveys the idea that the show is considered great, but it falls short of meeting the expectations that were set for it.