No, I have changed my mind-- the comma is not strictly needed before the
and, since the conjunction does not introduce an independent clause. However, I would still use it because I would wish to emphasize the sequence of events: (1) it will be short-lived, and then (2) it will be entertaining. If the depressing situation is not short-lived, it will have no entertainment value. The comma, as a pause, lets the reader consider each aspect individually.