What is your reasoning for why insuring manual cars would be any more expensive than it is now? If anything, it would be less expensive since those cars are sharing the road with safer self-driving cars.
If manual cars were comparatively more expensive then psychology might come into play and people would be reluctant to go for the more-expensive manual option.