A startup typically needs a fractional CMO once marketing decisions require strategic judgment — which market to enter, how to position against competitors, how to allocate budget across channels — rather than just execution. A marketing manager is built to run campaigns against an existing plan; a fractional CMO is built to set that plan.
If no one in the business can answer 'what should marketing be doing and why' with confidence, that's usually the signal, regardless of team size.