No. In rhetoric, an apostrophe (not to be confused with the punctuation mark) is a figure of speech where a speaker directly addresses an absent person, an abstract concept, or a personified object—something that cannot literally respond. Classic examples: "O Death, where is thy sting?" or "Romeo, Romeo, wherefore art thou Romeo?"
"Memory," sung by Grizabella in Andrew Lloyd Webber's Cats, is a first-person reflection. She sings about her past glory and present misery to the audience (or to herself), not to an absent entity. The lyrics—"Memory, all alone in the moonlight..."—are narrative and introspective. She does not apostrophize "Memory" as a personified presence; she describes the experience of remembering.
Therefore, while the song is deeply emotional and addresses themes of time and loss, it does not employ the rhetorical device of apostrophe.