Default value of rollback is register on Error Exception but when u register try{}catch{}
manually it overriding the error, so in this case use
catch {
TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
}
to do it manually or remove try catch
also you may register exception type in transactional annotation such:
@Transactional(propagation = Propagation.REQUIRED, rollbackFor = Exception.class)
your comment sent successfully and will show after approved by site administration .