What does the term mean and what is the best way to use it? And, I also wanted to know if there is any information about where it comes from. And by the way, how do we pronounce it?
It's an onomatopoeic term for an explosion or perhaps something collapsing in an horrendous cascade of messiness.
It use is normally half-joking, certainly informal.
A variant is kablooie as in "Horrendous Space Kablooie", a term used in a comic for the Big Bang that some scientists prefer. Mostly because they have a sense of humour, but also because "Big Bang" was coined to ridicule the theory, not to name it.
kerplewy is ker- + blooey. The OED says: