[BUG] Redirection issue for direct query datasource in dashboards management

[RyanL1997]

Describe the bug

When MDS is enabled, we are still having the card view in datasource detail page in here shows "query data in observability logs" and forwards user to log exploer page which should be disabled when MDS is enabled Same redirecting action is also being applied for specific accelerations

To Reproduce Steps to reproduce the behavior:

• enable MDS
• go to a direct query datasource's detail page
• video

https://github.com/user-attachments/assets/f5f78804-d679-4a5c-8fbe-43d6262a5b72

Expected behavior when MDS is enabled, it should be directed into Discover

OpenSearch Version main

Dashboards Version Please list the version of OpenSearch Dashboards being used.

Plugins

need dashboards observability plugin Screenshots

If applicable, add screenshots to help explain your problem.

Host/Environment (please complete the following information):

• OS: [e.g. iOS]
• Browser and version [e.g. 22]

Additional context

Add any other context about the problem here.

[dblock]

[Catch All Triage - 1, 2, 3, 4]