I haven't tried with Wolfram Engine, but if what they write is true, then it should work. Be aware that I haven't built against Mathematica for a long time, so things like the CMake support to figure out where the Wolfram software is located on disk may not work. Also, the code that bridges between Cadabra and Mathematica notation is not as tested as that to SymPy.
You do need the Wolfram software installed locally as Cadabra will need the headers of the WRSTP library https://www.wolfram.com/wstp/ to build. I cannot distribute those along with Cadabra as that violates Wolfram's terms.
If you do give it a try, please post here to let us know how it went.