Being the Freudian analytical mind that I am I believe it all goes back to Cin's infatuation with Zappa. The Moon represents a closeness with Frank
Bear with me as we study this post.
"Wham! Pow!" suggests a need to feel power with women
" Blue Moon, You saw me standing alone." yet at the same time represents our patient's yearning to be aknowledged by his true love
"If they can put a man on the Moon,....." I think what Cin really meant by this is a man IN the moon"
" Hey diddle diddle. The cat & the fiddle.".. A truly ironic reference to his musical past and Mr. Zappa.
" and if the band you're in starts playing different tunes, I'll see you on the dark side of the Moon." - Here Mr. Cin appears to reach out to his true love and ask her if she is open to possible lifestyle changes.
My professional opinion after reading this is that Cin really wants to fuck Moon Unit Zappa in the ass.
Cinserly Yours,
Rave Freud