Except that the sound can easily be disabled, finding the Airtag e.g. on a car may be difficult, and the police apparently doesn't do anything because the tracking notification alone isn't sufficient evidence of anything.
A really serious stalker could also glue an iPhone to the vehicle and track that via the Find My service- sure it’s costly but it won’t play any sound whatsoever nor reveal any tracking attempts via notifications.