Cosmic dissonance: are new physics or systematics behind a short sound horizon?