Today I learned how to alter lxd state by querying the internal database.

lxd sql global "select * from storage_pools"
lxd sql global "delete from storage_pools where id=4"