Dundee is probably typical of what SZD would be like. 2 flights a day to LCY
Dundee is a long way from London. As has previously been said, Sheffield is about two-and-a-quarter hours away by an hourly train.
And, as has been previously said, if MAN can't sustain flights to LCY, how could Sheffield?