The return type is VARBINARY(MAX) , so, it should be CASTed to a char type.
Also, there's an undocumented function UNCOMPRESS.
select UNCOMPRESS(decompress(COMPRESS('a')))
Try: it returns the starting string.