It's going to matter who you ask, but as a foreigner you're more likely to be talking to someone (relatively well-off, educated enough to have fluent English, probably not a fan of Erdoğan) who'd have preferred it to stay Turkey.
It's just another step in the trend of undoing Atatürk's reforms that has defined the current regime. To summarize a lot of history, the foundation of modern Turkey was a pretty massive upheaval. Atatürk (the first president of Turkey, and is viewed pretty similarly to the US's founding fathers) worked pretty damn hard to drag the country away from its Ottoman roots and towards being a Western, secular, country. Under the Ottomans, the head of church and head of state were the same person, under Atatürk, church and state were separated. Atatürk's government outright banned the wear of most religious garb in public, such as fez's and headscarves. Women were given full rights. The entire alphabet was changed from an Arabic script to a Latin one. And these are just the big ones I can pull off the top of my head.
Basically, imagine if George Washington had banned crucifixes from being displayed in public and switched the US's alphabet to Cyrillic.
It is impossible to overstate how radical these reforms were, and most were intended to bring Turkey closer to Europe both economically and culturally. The following 85 years of Turkey's history, up to the modern day, has been marked by tensions between those that generally like the reforms, and would like to see Turkey continue towards being a well-respected member of the West, and the conservative faction who want Turkey to backslide into an Islamic theocracy.
The name change is one of many postures Erdoğan has taken to distance himself from the former group, and amounts to a dog-whistle for the second.
TL;DR: It's whole fucking can of worms.