You end up with a lot more noise with simple histogram adjustment from a single image, plus the dynamic compression to a final 8bit image won't look as good for many use cases.

Exposure fusion from multiple images has much higher usable dynamic range and lower noise.