Deflating (( once in a while )) is normal.
But, that hole on the side is not a good sign at all. Any chance of getting a better picture of it? While I wouldn't take it out, I would keep a very close eye on it -- and try to keep the clown away from it, at this point it will only make things worse.
Is this for your 90 or 12? And what are the water parameters (( with numbers, including salinity )) and what lights do you have.