Avoid flakiness by introducing more conditional waiting

What does this MR do?

Fixes flaky test add_comment_to_snippet_spec by introducing more wait after comment actions as they take longer on staging.

Closes #267508 (closed)

Does this MR meet the acceptance criteria?

Conformity

• [-] Changelog entry
• [-] Documentation (if required)
• Code review guidelines
• Merge request performance guidelines
• Style guides
• [-] Database guides
• [-] Separation of EE specific content