Hi Babak. No, they would not any longer. Before, they were inside the BI-Tools such as Tableau, Superset, etc. or directly inside the Data Warehouse pipelines (transformations). A Metric Stores will be uncoupled, and all Metric will live independently. It will depend a bit on the implementations, though. If you use dbt, they will integrate it more inside their existing ecosystem, but it will be its component if you use MetriQL, Cube.js or others.
Regarding what is stored in the Data Warehouse: The Data will be there, sometimes aggregated, sometimes not (depending on the speed of your Warehouse). But you can't pre-store all your calculations before. There are just too many combinations that you can do, especially if you have a lot of Dimensions (if not, then it's easier). But those metric and aggregation logic can get very complex, and these would be typically stored in a Metric Store as a single place to use in all your BI and ML tools. I hope that helps. Otherwise, let me know :).