I (maybe naively) believe a healthy society could find a way to build a robust public transport network and still accommodate the minority of enthusiasts who drive and work on cars for fun.

Engineers aren't just dry husks of people, robotically creating solutions to meet needs. The drive to create cars, planes, and motorbikes, which have significant technical overlap with trains, buses, and mobility aids, is at least partially borne from the thrill of piloting machines that extend human capabilities.