How bad did I screw up

You ve the broken piece that could be welded back on. That "might" work. That looks like a blind hole with the water jacket on the other side so drilling deeper and re-tapping might not be a option. Good thing it was super cheap.