From foul-mouthed rants about colleagues to ‘appalling neglect’ of vulnerable people, those close to Boris Johnson revealed workings of government at height of pandemic