chore: Clean up dead code and consolidate duplicate scripts

[db-tycoon-stephen]

Problem

Multiple scripts have overlapping functionality or appear obsolete:

• health_check.py vs monitor_health.py (duplicate?)
• snowddl_wrapper.py (deprecated wrapper?)
• One-off investigation scripts: query_schema_owner.py, query_all_schemas.py, investigate_object_ownership.py
• Multiple dbt/schema ownership scripts that should be consolidated

Empty directories in src/web/ (components/, core/, features/, services/) with no Python files.

Proposed Solution

1. Audit each script for usage and relevance
2. Remove confirmed dead code
3. Consolidate overlapping scripts
4. Clean up empty directories
5. Update pyproject.toml to remove references to deleted scripts

Acceptance Criteria

• No duplicate functionality across scripts
• No empty directories without purpose
• All pyproject.toml entries reference existing code
• Removed code documented in CHANGELOG