Still in wide use in CPU caches. It does not scale well to smaller sizes, and inherently requires more transistors than DRAM, which means it's not cost-effective for main memory.
It sort of makes sense because SRAM cannot have the same transient nature of a calculations transistor. It has to hold the state for longer than one 3 billionth of a second. So it has to be a little more robust.
This is my intuitive take so it could be completely wrong.
(Of course, this is still very irrelevant for comparison to DRAM; the price difference is huge.)