The singing voice for Dr. Frank-N-Furter was provided by Richard O'Brien, who wrote the music and lyrics for the show. He also appeared in the film as the character Riff Raff.
Although Curry is known for his powerful stage presence and acting skills, he is not a professional singer. He's actually quite open about this fact and often jokingly attributes his singing abilities to his "excellent lip-syncing skills".