Sinn Féin falls flat in hugely ambitious local election