You've basically nailed the problem Sludge. Big city with little interest in its own team. If you visited every school in Cardiff and asked every pupil who their favourite team was, how many would say Cardiff City?
Try doing the same in places like Manchester, Liverpool, Newcastle, Sheffield etc, the results would be very different.