As to whether Star Trek: The Motion Picture brought in non-trekkers, consider that it generated the most worldwide boxoffice of the film series until First Contact.
The Motion Picture is still the one I return to the most. Khan is fun, III is awful, IV is general audience-friendly - the Tribbles of the movie series, V is unforgivably cheap, VI is silly but a decent sendoff.