What term best fits what a disappointment that play was?

The term "letdown" best fits the description of a disappointment regarding that play. It conveys the feeling of unmet expectations and dissatisfaction with the performance. A letdown suggests that the play failed to deliver the excitement or quality anticipated by the audience.