Dropping a CHECK in mariadb?
You must assign a name to the CHECK constraint during add:

ALTER TABLE `mydb`.`table1`
ADD CONSTRAINT check_json_validity CHECK(JSON_VALID(jsonf));


Then you may freely remove it by name:

ALTER TABLE
DROP CONSTRAINT check_json_validity;


If you forget to assing the name you may to see it in SHOW CREATE TABLE output.