I have had clients who are brilliant at coming up with titles. In fact, they come up with titles for their books first, then create the content around those titles.
I admire the talent of creating titles, however I always warn my clients to detach themselves from the titles if they are pursuing traditional publishing, as the titles they hold so dear can easily be changed by the publisher.
I also have clients who write their book first, then obsess about the title. They refuse to send the proposal or manuscript until they believe they have the perfect title because they're convinced that it will make or break their book. And when it comes to impulse buys, that's true. People really will buy a book because of the title or the cover. But if the content of your book is great, and your writing is fabulous, word will get around and readers will buy it because they heard about how wonderful it is. No one ever got a starred review from Publisher's Weekly because of the title of their book.
If a publisher says the title must be changed, there's probably a good reason for that and it behooves you to listen to it. Sure, you can still campaign for your title. But don't be too attached to it in the even your campaign isn't successful.