[Observability:Storage Explorer page]Sorting order is not changed when activating table headers

[L1nBra]

Description
For table headers, which are buttons with sorting order, when activating them - sorting order has to change.

Preconditions
Observability -> Universal Profiling -> Storage Explorer page.
Use Screen Reader (NVDA).

Steps to reproduce

1.Navigate to table.
2.Navigate through table headers and press Enter on them.
3.Observe table and screen reader.

UI elements + NVDA Speech Viewer

Actual Result

• Headers are announced as buttons, but when user press Enter on them - nothing happens (same if user clicks on them with mouse).

Expected Result

• When user press Enter, clicks on the buttons - sort order changes accordingly.

Meta Issue

Kibana Version: 8.17.0-SNAPSHOT

OS: Windows 11 Pro

Browser: Chrome Version 131.0.6778.140 (Official Build) (64-bit)

Screen reader: NVDA

WCAG or Vendor Guidance (optional)

• Understanding SC 4.1.2: Name, Role, Value (Level A)(https://www.w3.org/WAI/WCAG22/Understanding/name-role-value.html)
• Understanding SC 2.1.1: Keyboard (Level A)(https://www.w3.org/WAI/WCAG22/Understanding/keyboard.html)

Related to: https://github.com/elastic/kibana-team/issues/1254

[elasticmachine]

Pinging @elastic/kibana-accessibility (Project:Accessibility)