Remove MVs in favor of projections (where possible)

Many MVs were added to improve the performance of queries, however, some of them can be updated to use projections + a view to do not break existing reports.

Projections are supported on dbt-clickhouse v1.8.2: https://github.com/ClickHouse/dbt-clickhouse/releases/tag/v1.8.2