You do not need Xbox Live Gold.
Call of Duty 4: Modern Warfare (2007) on Xbox 360 uses a **local profile rank system** for offline modes:
Bottom Line: Pop in the disc, play offline, rank up to 55 / Prestige 10 (if you have time) — no subscription needed.