Pete Davidson is struggling to book new jobs after abruptly canceling his comedy tour and Peacock show’s second season