Fixes #28802

hermes_cli.kanban_specify currently uses with kb.connect() as conn: in helper paths like list_triage_ids() and specify_task().

For sqlite3.Connection, that pattern does not close the connection on exit. It only manages transaction scope, so repeated helper calls leak file descriptors in long-lived processes.

This patch switches those helper paths to explicit closing and adds regression coverage for sqlite-like connections whose context manager does not call close().

Validation:
uv run --extra dev pytest tests/hermes_cli/test_kanban_specify.py -q -k 'closes_connection or test_list_triage_ids'

Result:
3 passed in 8.46s

Live repro before fix:
{'base': 5, 'after': 52, 'delta': 47}

Live repro after fix:
{'base': 5, 'after': 5, 'delta': 0}