Video game pioneer John Carmack is resigning from his consulting position at Meta with "mixed feelings" about the "end of his decade in VR," he announced in a Facebook post