Do species ever go extinct by becoming too successful?
yes, infectious bacteria are a good example, a highly destructive infection may often kill its host before it can spread the disease.  https://www.ncbi.nlm.nih.gov/books/NBK27114/