I want this namspace to stop being a redirect for the trope Turns Red and use it for the article film Turning Red.I'm not sure if I can take this action in my own
Paging the admin squad: @Labster @Looney Toons @GethN7 @Robkelk @QuestionableSanity @Derivative @SelfCloak
Likewise. You should be able to just edit the page and replace the redirect code with your work page. You shouldn't require any special privileges.
Oh! You might want to put a line "Not to be confused with the trope Turns Red" at the end of the description of Turning Red, in case there are off-wiki links to the page.
I've taken care of the on-wiki links. Well, link. Other than the pages listing the film as an example, there was only one page using the redirect, which now doesn't use it at all. So feel free to replace it (if you haven't already, since I'm posting this without looking at Recent Changes).