[BETA] Container queries utilitis

### Overview

Adding container queries utilities to EUI originates from a feature request: https://github.com/elastic/eui/issues/8265. It has been introduced on this epic: https://github.com/elastic/eui/issues/8822 and is currently in **beta** due to gathering feedback on added utilities and their API. This issue is intended to track the progress and necessary actions to transition the functionality out of beta status and into general availability.

### Feature Description

Container queries utilities enable users to use CSS container queries with Emotion and EUI easily. The added Emotion helpers speed up the process of setting up CSS containers, writing at-rules, and the React hook creates new ways to access container dimensions in a performant way.

See the epic for more details https://github.com/elastic/eui/issues/8822

### Next Steps

To facilitate the transition, we should:

- [x] Analyze user feedback from beta testers
- [x] Address any reported bugs or issues
- [x] Update documentation for full release
- [ ] Define performance benchmarks (if applicable)