That was to snailboy - mc, no it is math.
Assuming you mean 76 psi, which is double the original 38 psi, then yes, there would be twice as much pressure on the ground (assuming it’s flat ground). The tire would have a smaller contact patch because the extra pressure makes it more rigid. It’s the same weight but less area to transfer it to.
So doubling the pressure reduces the footprint of a tire (cylinder) by half? Interesting trigonometry. How much pressure could I have before the tire (and vehicle) was weightless?
I already said the weight will remain the same, only the pressure will change, that is unless you rip a hole in the bottom of the tire and turn it into a hovercraft.
Yes, if the tire didn’t have any structural strength by itself. An actual car tire will deviate from this formula slightly.
It’s not trigonometry, just arithmetic:
Weight = pressure * area
If you increase the pressure to infinity, you’d end up with an infinitesimal contact patch. The weight is the same.