- Well, you've just answered your own question. To die without leaving anything behind, or to live a meaningful life with a sense of duty fulfilled and leave behind a great legacy for centuries to come? Which of these two options is sadder? And yet, the first option is far more common.
Perhaps a person believes that, like the native inhabitants of Helma, they have wings, and according to their self-perception, they need to jump off a cliff to be happy. But it would be better for both them and society if this path were closed to them and they were directed down a different path.
-- Let's put it this way: in the book about the queen-singer, the wording suggests general prosperity, but in a specific, important aspect for the heroine, there is dissatisfaction. Perhaps I misunderstood, or maybe it wasn't the character's opinion, but the author's. In any case, it's easy for me to say that I wouldn't like such a fate. Leaving a mark in history is a plus, everything else is a minus. In this regard, I felt a little sympathy for Lorenzia, judging her primarily by what is written, and secondly, by myself. Simple and clear.
-- In your example, I don't even understand the catch: a person dreams of jumping off cliffs, and then goes and jumps. Well, that's great, apparently, they are not interested in continuing the family, like you and me, and survival is not interesting, like you and me, let them do what they want, why is that bad?
-- Public good, in general, does not relate to feelings and emotions; it is an external factor that should be accepted and lived with, just like with physical laws, the will of other individuals, and so on. This good may correspond to your desires, or it may not. It does not prevent or help to sympathize with or, on the contrary, envy someone's fate... Unless you have no feelings except for public consciousness, but, no matter how beautifully it sounds, in reality this is hardly possible; we are not golems. Even if we try to completely discard the personal, we will still have cognitive biases, evaluation errors, and so on, which will not allow us to think objectively in terms of public good.