Google Trips will indeed work offline as long as you have the trip downloaded to the app and then you can travel and use Google Trips without need of a data connection.
However if you need to edit a trip that's already existing or create new trips then you will need a data connection to do those things but just to use Google Trips once your destination is downloaded you won't need a data connection.