Prominent leader of financial services watchdog resigns after report found it was riddled with a ‘misogynistic’ and ‘good ole boys club’ culture