I would, however, note that a heavier frame is likely to be less compliant and more likely to transfer road shocks. See,
This is true, but as you note it's less relevant the lower the tyre pressure. I have a 29'er with a real girder of a fork and 50mm tyres, I've done several back to back 100 milers with it between the lockdowns, very comfortable. If I'd put the 30mm tyres the Mercury sometimes wears on it, I expect it would have rattled my filling out. If you go for a front disc brake, it has to be pretty stiff however lightweight the bike. It's no coincidence that disc brakes and bigger tyres have grown in popularity at the same time!