I’m unclear as to the total cost. Who has been invited? Just the OP, or her son as well - and a partner, if there is one? (I ask, because it’s possible the OP might be on the hook for more than just her. It’s rare for teenage DC to pay their own way at weddings!)
If just the OP - could she share a room with another relative to split the cost of a twin room?
£500 is just for (one?) room for the night, but there will also be taxi/minibus/petrol costs, clothes, gift, etc to consider.
Depending on the total cost, if I was close to my niece, I would be pushing to make it work. There does however come a financial tipping point where a wedding feels ridiculous to you as a guest. In such a circumstance, I’d decline, send a cash gift and a card, and perhaps record a video message for the day. I’ve seen this before where guests who live too far from the venue have sent their best wishes as a video message, or even just words to be read out in one of the speeches.
TBH though, if I couldn’t make it work and my niece and I actually liked each other, I feel there would be a sharp change of logistics.