I've worked on exactly one website that used XSLT (via Cocoon) in ten years, and know of nobody else personally that has. Relative to the other options out there, it's essentially unused.
However, if all you need to do is convert XML to HTML, XSLT is quite handy. It eliminates steps like XML Parsing + Object-XML mapping, JSP processing, which are otherwise required in a traditional rendering technology.