Describe the bug

As an admin, when exporting comments from a component (i.e proposal component), the export file contains:

• hidden comments (after they have been moderated by an admin)
• deleted comments (users can delete their comments since Allow users to comment and delete their own comments #8072)

The export doesn't display any column that shows that those comments are hidden or deleted on the platform. This is a problem, because the admins have then to go manually to the platform to know the comments that have been deleted or hidden, and then remove them manually from the export file for further analysis.

To Reproduce

1. Go to a proposal show page
2. Report a comment and hide it in the moderation panel
3. Write a comment, then delete it
4. Export the comments for this proposal component
5. See that both comments will be displayed

Expected behavior

As an admin, I'd like the comments exports to contain only the comments that are visible on the platform, so to exclude hidden and deleted comments.

Screenshots

The proposal have a hidden and a deleted comment:

Both those comments are displayed in the exports, with no indication of their deletion or moderation:

Stacktrace

No response

Extra data

• Device: All
• Device OS: All
• Browser: All
• Decidim Version: 0.28.0.dev, 0.27, 0.26
• Decidim installation: nightly, try, client installation

Additional context

For further details, see this comment by Antti:

          I also believe currently comment exports will contain the moderated comments based on this:

decidim/decidim-comments/lib/decidim/comments/export.rb

Lines 14 to 16 in 06a7568

	Comment
	.where(decidim_root_commentable_id: resource_class.where(component: component))
	.where(decidim_root_commentable_type: resource_class.to_s)

E.g. at proposals:

decidim/decidim-proposals/lib/decidim/proposals/component.rb

Lines 151 to 153 in 06a7568

	Decidim::Comments::Export.comments_for_resource(
	Decidim::Proposals::Proposal, component_instance
	).includes(:author, :user_group, root_commentable: { component: { participatory_space: :organization } })

Originally posted by @ahukkanen in #6398 (comment)