It’ll be the end of Andrew but not the monarchy, which has been around for more than a thousand years with far worst scandals than this, I would imagine. The Camilla tapes and the cash thing, if it’s true, are not on the scale of what Andrew has done.
The king (“Charlie-boy”?) has done everything he can to unlink him from the family and he will now be removed from succession by the government. He also needs his security removed. That is an absolute outrage that he gets protection still.
So YABU it won’t be the end of the monarchy.