If you cannot be replaced, you are un-promotable. Your entire career becomes tied to a single point of failure. Then, when they replace that piece of software with a new product you have no experience elsewhere.
If you work for a company in stasis or worse, shrinking, then being replaceable means little.