The UK faces a critical shortage of skilled tradespeople that threatens to undermine ambitions on housing and net zero, a new report is warning.