The singer's film coincided with the release of her 12th studio album, The Life of A Showgirl, and left The Rock's movie as well as Leonardo DiCaprio's new dramedy One Battle After Another in the dust