Loads and validates the project manifest from .foundry/manifest.exs. Returns a validated Foundry.Manifest record or raises on error.