Mordenkainen's Sword is bad, but I would argue that Contagion is even worse. For example, M's Sword is on the Bard list, but Bigby's Hand is not. So, you know, conceivably, somebody could hand me a pregen Valor Bard sheet where he'd used Magical Secrets on healing spells, and M's Sword was his 7th-level pick, and you know what, I'd probably cast it at some point.
By contrast, I would never cast Contagion. Ever. It's most likely outcome is...nothing. The majority of monsters have good CON saves, and even if they don't, assuming you even hit, it's going to typically be 4-5 rounds for it to take effect, by which point just about any monster worth using a 5th-level, single-target spell on will be dead. I'd rather upcast Guiding Bolt than this piece of trash.