Comedian says Newsom is only fit to run 'the bottom of the sea' after LGBTQ+ U-turn