I added RSS embed code inside the Embed custom field.
While trying to show it in the block editor it does not show the result and it just shows the code.
Solution:
To add RSS embed code use the Paragraph default block and use the Dynamic Source button to retrieve the custom field and it will work in the front end.