This American city hadn’t seen a major sporting victory in over two decades. It took one English sport – and a devoted fanbase – to change that