Hello, can someone tell me if it's possible to make renders like in this portfolio with Sweet Home 3D?

Sure, look at the renders in these threads:
https://sweethome3d.com/support/forum/v ... read,12648
https://sweethome3d.com/support/forum/v ... hread,8832

And lately some members have taken it way beyond that:
https://sweethome3d.com/support/forum/v ... read,13273
https://sweethome3d.com/support/forum/v ... read,13237