Leo Palmer used to tour as a backup singer with several rockstars. He was happily married