SCTP is very much alive and kicking. In fact I have just been debugging an issue with it before reading this post. It's used between Mobile Network Elements, especially in the 4G Space, as the transport that DIAMETER sit on top of.

So I agree it's niche, but it's far from a failure.