Electrics will break that association. Or it will create a new expectation about what a fast car sounds like. Because from now on, they will always be faster than ICE vehicles.
I think there will be a niche of people buying ICE cars for their loud sound, just as there are people who buy the loudest possible motorcycles even though they're not very fast. But I think this will be a niche, and they will probably be considered obnoxious people.
I think we'll also see more sound engineering in EVs. They'll perhaps get a more satisfying sound, but will still be quiet.
Although I seem to recall that many cars bought for sound already play synthesized motor noise through the speakers, simply because if the shift to smaller, better performing engines means that they don't have the same sound anymore anyway.
The best combination is ultimately both though, hybrid systems are already used quite frequently in everything from LMP1 WEC racers to modern hypercars.