Why a failure? As you say this is a niche topic and if the info is correct on Amazon, it has only been out a year and a half.
I am an author of a robotics book in an even more niche topic and I doubt our royalties totaled more than ~$5000 in the 4 years its been out (no upfront payment). I've always considered it as something to put on the CV more than anything else.