I'll add that when Adobe CF introduced a "richer" script syntax, it wasn't complete and along the lines of too little, too late. This is where MACR stagnated. Had CF introduced a full blown scripting language in the early 2000's, CF would certainly have a little more staying power these days, especially with open source implementations like Lucee.
The biggest problem for ColdFusion is that there was a time (2008-ish) that the open source web development world innovated and evolved by leaps and bounds around it and CF stood still. One of CF's biggest selling points was that it wasn't open source and that it wasn't PHP. I'm not knocking PHP; the reality was that there were a ton of companies that would steer clear or open source projects back in the mid-2000s. If you were doing "enterprise" web development in 2003-2005, you were either doing Classic ASP, Java, or ColdFusion.