Exclusively use pinecone-local in unit tests and remove delays

[jamescalam]

We need to remove all retry and delay logic in unit tests, which were added due to pinecone-local use. This has been done for tests/unit/test_sync.py here