Is it weird for flatulence to smell sweet?

No. It is probably due to your food. However, do not expect others to find you flatus pleasant.