The film, which premieres on Sept. 6, marks the singer’s silver-screen debut