Note that output is marked as 24 V DC, so there must be a rectifier and filter inside, apart from the actual transformer. And this doesn't sound like a usual combo to me.
If the case isn't glued/sealed, it may be fairly easy to repair it, as it's unlikely that it's the transformer itself that failed, and, since it seems to have a good old 50/60 Hz mains transformer inside, followed by a diode bridge and a filter capacitor, the failed part must be one of the latter two, each being trivial to replace.
There may also be a fuse inside that blew, in that case replacing it may get the transformer working again, but it'll require to figure out why it blew in the first place, or the problem may happen again.
If a full replacement is necessary, it can, most likely, be replaced with a switch mode PSU (much more common today than linear types) with the appropriately rated output, but it's desirable to confirm that the intended load's input doesn't require anything specific and is indeed designed for a 24 V DC supply.
p.s. it seems to be designed for outdoors use, so any replacement or repair has to keep a reasonable level of moisture protection, if that's so.