Hi Niels,
Two community discussion threads on this subject may interest you:
https://lists.openstreetmap.org/pipermail/talk-gb/2023-May/030407.html
https://lists.openstreetmap.org/pipermail/talk-gb/2024-February/031142.html

In summary, these large sites offer a wide range of services from day-passes to attractions, pitches for caravans/ tents/ motorhomes making one overall tag like tourism=caravan_site or tourism=chalet meaningless, especially without specific activity tags.

 I'm leaning towards adding specific usage tags, and tourism=holiday_park (more neutral across several activities):
tourism=holiday_park
caravans=x
tents=x
motorhome_stopover=x
static_caravans=x
permanent_camping=x
internet_access=wlan
landuse=commercial	(belt-and braces)

This approach gives the specific services for data-consumers. The local community discussion is continuing, so edits will wait for more of a consensus.
Happy Mapping,

James
