The example you gave is a loser. You should not have been in the hand. This is a big problem being a new player.
Yes, playing suited connectors can be profitable, you are playing them in the wrong situation which can cost you a lot of money.
If you are limping with a speculative hand, it needs to be one that has the potential to flop a BIG hand. A good example is a small pair looking for a set. Another good example is a small suited Ace. If you flop a flush, you have the nut flush. Playing for a low flush or small straight in a limped pot will end badly more often than not.
The time to play suited connectors is actually when it is a raised pot. This is where a poker calculator really helps. Hands like 45s, 87s, are good hands against big pairs like AA, KK. You can make a straight, flush, flop 2 pair, trips, ect.. In micro limits villains commonly raise big cards, it can be profitable to play suited connectors in position. In limped pots, they go in the muck.