I don't care how good a song is - if it holds back the storyline, stalls the plot, your audience will reject it.
I think if you are going to be a singer, you should sing. If you are going to be a dancer, you should dance. If you are going to do a combination of the two, you should make it very clear when you are singing and very clear when you are dancing.