I think it's ugly. It introduces uncertainty about the exact semantics of statements (as in does this code really do what I think it does?). It doesn't add any capabilities which JavaScript doesn't have. It makes debugging more complex, because errors are not actually happening in the code you wrote, but code a compiler wrote based on something else.
It introduces indirection and complexity, while adding zero value. As such it's on overall a negative value proposition, and that's everything it takes for me to decide something is not worth it.
I find it a perfectly rational decision and attitude.
While I'm not a fan per se, at least other transpired languages like typescript and clojurescript at least adds new capabilities to justify the additional complexity.
Definitely not calling you irrational - I really was just curious. I actually find your analysis pretty straight on. I realize now that part of the reason I like Coffeescript is because I like the way it looks! I'm more of a hobbyist, and haven't really had time to keep up with the latest developments in JavaScript, but I do understand a lot of the original reasons for CS may have been covered by the latest ES6.
