Comic Relief has apologised to its supporters after Frankie Boyle caused controversy at a charity gig with a string of gags about the Queen of England.