How long should my battery last (when not in use)?

The TT is not your car or truck
Unless you disconnect the battery or include some type of near constant charge Trickle, shore, solar
The various control board circuits will suck it dead

I'm not sure you could leave your tow vehicle sitting for five weeks and still have a good battery, maybe.. maybe not

But you sure cannot do that with a modern RV