Delete a role.
Deletes the role and all associated permissions. Default roles (admin, user) cannot be deleted. Only superadmins can delete roles.
Args: role_id: Role ID. current_user: Authenticated superadmin user. request: FastAPI request object. session: Database session.