Compost can be a lot lighter than 38 lbs/cu ft. It depends on the moisture content. If it was outside in dry weather for awhile, it can get very light, but one rain will make it very heavy. Once it has settled, it won’t move around.
I would get it out of there though, its only good in the garden, not in the trunk of a car.