It’s about as serious a punishment as the Commons has. Assuming the report is approved by the Commons, he’s up for a recall petition which will only let him keep his job if his constituents allow it. Remember that this isn’t a criminal court of law, there’s no police or lawyers on both sides. And it can’t be allowed for MPs to “just be fired”, as that power could be misused by any party in power to oppress their opposition.