So basically I successfully changed my account name to my real name but my profile name(The name that other upwork users see) is still the same old nickname that I don't want. What do I do?
The name you use should be your real legal name.
This applies to the profile name as well as the account name, and the name you use on your payment withdrawal method.
The thing to NOT worry about is your Upwork "username," which is the name you enter when you log into the site. This is not a name displayed to users.
I checked your account, and can see that your account name matches the name on your profile. If you are not seeing the same information, you can let us know and our team will be happy to assist you further.