I didn't really like that Aqua has to die, but with the epilogue, I kinda able to accept it more...
Without Aqua's death,I doubt Kana would be this successful if Aqua is still around. More likely situation is she'll just stay successful in national level for a little long while, then marry Aqua and fade away, being just another great actor of the time past.
Without Aqua's death, the industry would probably stays the same, Ichigo Pro wouldn't push for a new standard like that.
Without Aqua death, Melt would have been a good actor, but might not be as successful; being outshine by Aqua and whatnot.
Without Aqua's death, Akane wouldn't have spiraled into this state - this one is truly unfortunate.
If he had lived, the industry might continue to be flawed, but everyone would be a lot happier. He might find happiness and what to live for someday. Even though there's some good thing in it, it sucks for everyone that things turned out like this- that's for sure. Aqua's decision is far from perfect, arguably dumb - no doubt.
But it's only human.
That's how human are. We aren't perfect and just do things we think its the best we can see. And then life goes on. Everyone has to handle all the goods and the bads in their own ways. Some copes well, some don't. And considering the man himself at the time didn't have any other life goal, he might still chose suicide even if he know everything will turn out like this anyway, who knows?
Maybe its because I'm old now that I find the sunshine & rainbows ending bland sometime. I still love it every now and then, don't get me wrong; but a portrayal of very real, unperfect world like this is very cathartic to me.
And as a last note, in a story about show biz themed around revenge like this, between a happy ending where everyone lives a happy life but faded out of the industry as just another 'great' figure of their time, and a tragic ending where everyone becomes a 'legend' in one way or another like this, I find the latter very fitting end for the whole a lot more.