I don't think you need to be dysphoric to want to be forgotten. I don't think it's any less reasonable than wanting to have a legacy.
The real question is, what does the "right to be forgotten" even mean? You can't have a right that involved other peoples' thoughts. In most cases I think it's the right to be able to own and remove records you created on third party systems.
The right to be forgotten, as I usually read it, is the right to have Google or Meta or whatever to remove your account and everything associated with it. I wish that were law.