The Royal family brings in more money than it spends through tourism. Its existence sells merchandise, creates an invaluable marketing tool and creates a buzz around the nation in general.
The Royal Finances are transparent and accountable. This means that excess spending will likely be caught and prevented. If the Monarchy isn't actually a substantial drain on public finances, and brings in other substantial diplomatic, PR and soft-power benefits, we have no reason to abolish it.