This is where you are letting yourself down - it’s not TTN that’s not keen on downlinks, it’s ALL LoRaWAN networks - and you do not appear to know why and you do not appear to have gone to find out what the problem is for a local area when a gateway is transmitting a downlink.
Downlinks are fine here and there - I figure on one a fortnight for device signal strength check for a device that is in a ‘safe’ coverage zone. And occasionally a device may need its configuration changing, typically on season change (no point monitoring soil moisture levels whilst there is no crop in the fields, may as well save battery life).
But if your use case for a device is fundamentally reliant on downlinks, you need to rethink the use case. Because connectivity is not guaranteed, by which we mean it may not get through for a number of hours, days even.
It is also a bit unfortunate that you have chosen a tracker as your first device, as the usefulness of such a thing with LoRaWAN is questionable at best and often prone to not meeting expectations. Again, multiple discussions on the forum for you to read.
TTN Mapper is for radio / gateway coverage - it’s an engineering application, not something end users will benefit from.
I think you gave up too quickly on the water meter - there are other ways to detect water issues as mostly they come from leaks and detecting leaks is something that LoRaWAN is a very good use case. You could have 100 of them setup before the cold weather starts bursting pipes and provide an excellent first project for your community.
And while you are working on the water issue, you can research fire detection for your forests for spring.