Currently, when the client application is set to Avoid major highways†, the Waze routing engine will only avoid freeway road types. This may change in the future, but that is how it operates now.
† Depending Language set this may be different (eg English (UK) is "Avoid motorways")