Add polished transition/interaction states to ConnectedProvidersStatus

[Wilfred007]

What

Add polished transition/interaction states to ConnectedProvidersStatus.

Why

ConnectedProvidersStatus currently has abrupt state changes (hover, open/close, load) with no considered transition, animation, or feedback state.

Scope

In scope:

• Implement the transition/animation described for frontend/src/components/ConnectedProvidersStatus.tsx
• Respect prefers-reduced-motion
• Keep animation duration/easing consistent with the motion token system
• No layout shift or jank introduced (verify at 60fps)

Out of scope:

• Introducing new motion tokens beyond what already exists (tracked under the motion token system issue)
• Changing the component/page's functional behavior

Acceptance Criteria

• Animation implemented and matches motion tokens
• prefers-reduced-motion disables/simplifies the animation
• No layout shift introduced
• Reviewed for 60fps performance

Technical Context

• Relevant files: frontend/src/components/ConnectedProvidersStatus.tsx
• Follow existing patterns in @stellar/design-system usage and frontend/src/providers/ThemeProvider.tsx for theming