Is the song Memory from Cats an example of rhetorical apostrophe?
No.
In rhetoric, apostrophe is a figure of speech in which a speaker directly addresses a person or thing that is not there or personified as being present.
The song Memory from the musical Cats contains no such rhetorical device.