Somehow I get the 'vibe' that there are two particular kinds of zoo that are host to nocturne houses. These two would be the dense inner city zoo, and then the smaller zoo hosted by someone with a particular passion.
In the case of the inner city zoo, many nocturne houses are in essence a 'remnant of their time' - in the ~70s era when zoos were keen on filling their land area up rather well. And so the nocturne house was seen as the answer to the question of making certain animals more viewable; and in a relatively small area of space to boot.
But as many things do the ideas that put that of the nocturne house fell out of favour, with the transition from borderline megalomania at the near-end of the twentieth century towards a more natural quality of life in the late 20th/first quarter 21st. And so the 'era of renovation' began. Enclosures gradually became larger on the whole; which had the effect that was desired - a more natural life provided in a larger area, but in some cases, like in Paris, the renovations also had the effect of sacrifices having to be done. And in the eyes of those who wished for a more naturalistic zoo, the relatively small, relatively 'closed-in' nocturnal house was a somewhat easy target.
And since then, not many totally new such enclosures have been built since in larger zoos.
Certainly in the US of A the prevailing model for new exhibits built in the first quarter of the 21st, amongst major zoos, seems to have been 'build atop what has been done before'. That is, the 510th iteration of the African Savannah or the totally new twist on the lion enclosure which is totally new because it's one of the only ones in your state. And to some degree Europe has followed along, in regards to what they have been building this quarter century anyways, but somehow has managed to maintain some deal of diversity between collections [Nocturama or none, Antwerp still has over 500 species listed on ZTL]. And that is to say that even in nocturnal houses as a whole there are some species which are or were 'expected'. Aardvark, sand cat, springhaas, bushbaby, doroucouli... and whichever speciality animal the zoo nerds come to see. And even then some city-zoos have reinvigorated their nocturne houses to make them more 21st-century appropriate... Berlin being one of them!
And so we get to the second type of nocturnal house... the ones less so of major zoos within a big European city and moreso smaller collections an hour in any direction of them. These on the other hand have had the longer end of the stick. I'd imagine part of the reason for their appeal in smaller collections is two-fold - part of it being 'we don't have the room for a rhino, but we can totally build a smaller area with numerous species within it', and part of it being 'if the big guys aren't going to maintain these species, then it's up to us!' And to speak from the UK, this is the main type of nocturnal house here now - mainly because there's only really one inner city zoo in the UK! [There used to be two; London and Bristol, but the latter closed in 2022. Both had nocturne houses] In the UK, nocturne houses have managed to become a staple of smaller collections, and even many larger collections seem to make room for a bat house or something of the sort. Longleat I think qualifies as a major collection of the UK, and they recently re-opened their bat house - and that was after they released a statement that it would never open again!
So I think in some respect, there is a certain decline of a certain type of nocturnal house, with bigger zoos that attract more visitors going the direction of the masses to provide a 'bigger' zoo experience which may be less species dense. And so we see the loss of various nocturnal houses in inner city zoos. But amongst smaller collections, they do seem to be a viable exhibit!