Püss is definitely still going, though personally I haven't been there in about a decade. Was more my kinda jam back in university, but it was just so loud I couldn't stand it anymore at some point.
I can tell you though that Rüütli street feels dead compared to a decade+ ago. Like there's still bars, there's restaurants, they all seem to be doing well enough to stay open... But at least when I last visited it on a spring evening a few years ago, it wasn't as swarming as it used to be in say 2014 or 2015. Of course I guess that was when we still faintly remembered that COVID exists, maybe 2021 or 2022, so perhaps it's changed for the better.
There's also plenty of great bars to visit that have been open for a while and are still going. Möku (in the rooms of Genialistide Klubi for well over a decade now), Pirogovi Lokaal and of course Barlova. They all seem to be doing well, the nightclub scene has taken a much bigger hit than the bar scene IMO. I may of course be biased as well, I've never liked night clubs and I don't overly like socializing with the type of people that love night clubs, I like bars and I like people that like bars. If that makes sense at all lol