Report points to 'failures of leadership and judgment' among PM's staff, providing detailed information on lockdown gatherings; critics say scandal justifies his resignation