The Prudential chief executive has turned down an offer from Société Générale of a seat on the French bank's board a day after the announcement drew fire from shareholders